3 messages in com.mysql.lists.mysqlRe: using LIMIT 10, 40
FromSent OnAttachments
Paul DuBois04 Mar 2002 15:17 
Arjen Lentz04 Mar 2002 15:57 
destr004 Mar 2002 16:52 
Subject:Re: using LIMIT 10, 40
From:Paul DuBois (pa@snake.net)
Date:03/04/2002 03:17:05 PM
List:com.mysql.lists.mysql

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.