i have the datatable stored inside a table variable when the program starts up.
What i'm worried about is loss of connectivity for the user and some users have 56k connections. How does a mysql script look up a the row for which child im looking for? Like does it use a binary search or some better way?
I have my function to detect the row for every textbox validation which is upwards up of 20 validations. I hope that mysql script is the best to go with.
SO using "select * from table1 where name='john'" will give me the row count i need?