Re: Questions about LIMIT/OFFSET

On Oct 19, 2007, at 16:03 , Josh Trutwin wrote:

> SELECT * FROM table WHERE foo="bar" ORDER BY abc LIMIT x OFFSET y;

The server will have to generate at most OFFSET + LIMIT rows,
returning LIMIT rows or fewer.

> SELECT * FROM table WHERE foo="bar" ORDER BY abc;

This will return all of the rows available.

Unless you're going to be returning all of the rows where
foo="bar" (e.g., executing multiple LIMIT OFFSET queries) in one
request, I should think the first query would be more performant:
fewer rows for the server to process (in the final step at least) and
less data transmitted between the server and your application.

Michael Glaesemann
grzm seespotcode net