scrollable result sets performance problems

From: "Radim Kolar SF(dot)NET" <hsn(at)sendmail(dot)cz>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: scrollable result sets performance problems
Date: 2007-04-11 08:31:34
Message-ID: 20070411083134.GB50351@sanatana.dharma
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Xavier Poinsard 2007-04-11 08:51:05 Re: random escape function
Previous Message Kris Jurka 2007-04-11 08:21:38 random escape function