Hi, If I have a SELECT that returns a large number of results, say > 1000, then returns the results for the SELECT takes much over an order of magnitude longer than if the results set had been, say, 100.
Now, is there any way I can quickly return the length of the result set withotu actually returning the result set itself? This is part of a searching application, and all a result size of > 1000 means is that the user needs to refine their search parameters, so penalising them for it is a problem ;-) Any help greatfully appreciated :-) Chris (MySQL question, obviously ;-) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
