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, 40destr04 Mar
  • Re: using LIMIT 10, 40Paul DuBois5 Mar
  • Re: using LIMIT 10, 40Arjen Lentz5 Mar