scrollable result sets performance problems - Mailing list pgsql-jdbc

From Radim Kolar SF.NET
Subject scrollable result sets performance problems
Date
Msg-id 20070411083134.GB50351@sanatana.dharma
Whole thread Raw
Responses Re: scrollable result sets performance problems  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
I have performance problems with scrollable result sets, it looks like
all rows are fetched despite ResultSet.setFetchSize(). its major
problem with sets about 11m rows in size and query execution takes a long
time, so limit/offset can not be used..

any known workarounds? I am porting oracle app to pgsql.

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: random escape function
Next
From: Kris Jurka
Date:
Subject: Re: scrollable result sets performance problems