| From: | "Radu-Adrian Popescu" <radu(dot)popescu(at)aldratech(dot)com> |
|---|---|
| To: | "Yves Vindevogel" <yves(dot)vindevogel(at)implements(dot)be> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Speed with offset clause |
| Date: | 2005-06-25 11:42:44 |
| Message-ID: | 47992.193.138.218.24.1119699764.squirrel@www.aldratech.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
> I just ran this query
>
> select p.* from tblPrintjobs p , (select oid from tblPrintjobs limit 25
> offset 622825) as subset where p.oid = subset.oid
>
I'm just curious here, from a social point of view. How often do you think
someone will paginate over say 300K rows in steps of 25 ?
The way I see things, pagination is only meant for humans. If someone
really looks at 300K rows then it's really cheaper and makes more sense to
download them/import into spreadsheet program instead of clicking next
12.000 times.
If it's not intended for humans then there's better ways of doing this.
Regards,
--
Radu-Adrian Popescu
CSA, DBA, Developer
Aldrapay MD
Aldratech Ltd.
+40213212243
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Luke Lonergan | 2005-06-27 06:23:05 | Re: COPY FROM performance improvements |
| Previous Message | Radu-Adrian Popescu | 2005-06-25 10:45:27 | Re: Performance - moving from oracle to postgresql |