Re: raising the default prepareTheshold - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: raising the default prepareTheshold
Date
Msg-id Pine.BSO.4.56.0409200354270.12765@leary.csoft.net
Whole thread Raw
In response to raising the default prepareTheshold  (Oliver Jowett <oliver@opencloud.com>)
Responses Re: raising the default prepareTheshold  (Oliver Jowett <oliver@opencloud.com>)
Re: raising the default prepareTheshold  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc

On Sun, 19 Sep 2004, Oliver Jowett wrote:

> I'd like to raise the default prepareThreshold to some non-zero value,
> perhaps 5 or so. This means that PreparedStatements that are used more
> than 5 times will allocate and use a named backend statement.
>

Seems like a good idea and I think five is a nice conservative number.

At the same time do you think we should change the default fetchSize to
1000 or so?  Even though it only works for FORWARD_ONLY ResultSets it
could reduce the number of complaints we see here without much penalty.
Previously the cursor implementation was more limiting by ruling out
server prepared statements.

Kris Jurka

pgsql-jdbc by date:

Previous
From: Csaba Nagy
Date:
Subject: Re: "Idle in Transaction" revisited.
Next
From: Kris Jurka
Date:
Subject: Re: Detecting SQL_ASCII databases