Skip site navigation (1) Skip section navigation (2)

Re: Speed with offset clause

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: (view raw, whole thread or download thread mbox)
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.

Radu-Adrian Popescu
CSA, DBA, Developer
Aldrapay MD
Aldratech Ltd.

In response to

pgsql-performance by date

Next:From: Luke LonerganDate: 2005-06-27 06:23:05
Subject: Re: COPY FROM performance improvements
Previous:From: Radu-Adrian PopescuDate: 2005-06-25 10:45:27
Subject: Re: Performance - moving from oracle to postgresql

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group