Re: raising the default prepareTheshold

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