Probably a very basic and stupid question, but I am going through some older apps and fixing returns for various searches and was wondering about some very basic rules that should be followed and how they impact the search time to the db.
I think, and please correct me if I am wrong... 1. searching for 1 unique record should show Get total number of matching rows unchecked, Limit to 1. 2. searching for 10 records should show Get total number of matching rows unchecked, Limit to 10. 3. searching for all records but show 10 at a time (scroll through next and previous) should show Get total number of matching rows checked, Limit to 10. 4. searching for all records and show all records on a page should show Get total number of matching rows unchecked, No Maximum. Where I am confused is with #4. Wouldn't having both Get total number of matching rows checked and No Maximum give you the same results? Is there more of a server hit for this? Or is the Get total number of matching rows just a count and No Maximum and Limit is the actual number of results returned. Sorry for the brain fart moment ;-) ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe terascript-talk" in the body.
