Re: setFetchSize - Mailing list pgsql-jdbc

From fschmidt
Subject Re: setFetchSize
Date
Msg-id 1319644122794-4940158.post@n5.nabble.com
Whole thread Raw
In response to Re: setFetchSize  (Dave Cramer <pg@fastcrypt.com>)
Responses Re: setFetchSize
List pgsql-jdbc
Dave Cramer-8 wrote:
>
> There is little hope that you will get what you want. I'm not even
> sure I think it's a good idea as cursor with hold consumes resources
> on the server which multiplied by an unknown number of connections
> might end up being significant.
>
And how is it any better to force users to open a new connection to use
setFetchSize?  This would use just as much resources if not more, right?  It
is just much more inconvenient for programmers, especially in applications
like mine that are designed to use one connection per thread.

If there is little hope of getting what I want with Postgres, then I will
eventually have to look for an alternative database.


--
View this message in context: http://postgresql.1045698.n5.nabble.com/setFetchSize-tp4935215p4940158.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.

pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: setFetchSize
Next
From: Dave Cramer
Date:
Subject: Re: setFetchSize