At 16:53 -0800 3/4/02, destr0 wrote: >Is it faster for mysql to return all of the rows in a table, or to return a >set of rows picked out with a call like LIMIT 20, 40
The latter. Less traffic over the network. > >I tried to test this myself from the shell, but seeing as how it's running >on localhost I just get 0 seconds everytime. --------------------------------------------------------------------- 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
