> 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
If it's not intended for humans then there's better ways of doing this.
CSA, DBA, Developer
In response to
pgsql-performance by date
|Next:||From: Luke Lonergan||Date: 2005-06-27 06:23:05|
|Subject: Re: COPY FROM performance improvements|
|Previous:||From: Radu-Adrian Popescu||Date: 2005-06-25 10:45:27|
|Subject: Re: Performance - moving from oracle to postgresql|