|List:||General Discussion||« Previous MessageNext Message »|
|From:||Paul DuBois||Date:||March 4 2002 11:17pm|
|Subject:||Re: using LIMIT 10, 40|
|View as plain text|
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.
|• using LIMIT 10, 40||destr0||4 Mar|
|• Re: using LIMIT 10, 40||Paul DuBois||5 Mar|
|• Re: using LIMIT 10, 40||Arjen Lentz||5 Mar|