On 6/27/08, Bill Thoen <bthoen(at)gisnet(dot)com> wrote:
>
> What I want to do is present the results of a query in a web page, but only
> 10 rows at a time. My PostgreSQL table has millions of records and if I
> don't add a LIMIT 10 to the SQL selection, the request can take too long.
> The worst case scenario is when the user requests all records without adding
> filtering conditions (e.g. SELECT * FROM MyTable;) That can take 10-15
> minutes, which won't work on a web application.
>
>
Also note, that huge OFFSET value can slow down the query as much as if you
weren't using LIMIT at all.
--
Sincerely yours,
Olexandr Melnyk <><
http://omelnyk.net/