Hi, I think indexing the column(s) can help you. But there are certain criteria before you use indexs (like number of duplicate values in the column ..blah blah..) u can find more on this page http://www.linux-mag.com/cgi-bin/printer.pl?issue=2001-06&article=mysql i hope this will help you. Neeraj
Chris Withers wrote: >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 > --------------------------------------------------------------------- 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