Hi,
On Tue, 2002-03-05 at 10:53, 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
Well, the server has to first create the whole result set in the proper
order etc, before it can do the limit. But t
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 lo
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
I tried to test this myself from the shell, but seeing as how it's running
on localhost I just get 0 seconds everytime.
--