Matt Magoffin wrote:
>> I'd suggest using LIMIT/OFFSET in your query.
> Hmm, I had thought of that but was hoping to stay just in generic JDBC,
> without Postgres specific SQL changes.
Doing it in the query does have the advantage that the server can
potentially come up with a better query plan.. assuming that it's common
to page through less than the full query output.
In response to
pgsql-jdbc by date
|Next:||From: Albe Laurenz||Date: 2008-09-25 06:53:43|
|Subject: Re: COPY support in JDBC driver?|
|Previous:||From: Matt Magoffin||Date: 2008-09-24 23:01:45|
|Subject: Re: very large result sets and ResultSet.relative() to jump
to a desired offset|