| 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.
| Thread | ||
|---|---|---|
| • 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 |