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.0409230201390.25933@leary.csoft.net
Whole thread Raw
In response to Re: raising the default prepareTheshold  (Kris Jurka <books@ejurka.com>)
Responses Re: raising the default prepareTheshold  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc

On Mon, 20 Sep 2004, Kris Jurka wrote:

> 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.
>

Actually a little testing shows that a non-zero fetchSize implies using a
named statement instead of the unnamed statement.  So there will be some
potentially negative planning differences, so I'm going to retract this
suggestion.

Kris Jurka

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Auto-increment serial (Postgresql JDBC driver w/
Next
From: Oliver Jowett
Date:
Subject: Re: raising the default prepareTheshold