Re: CVS JDBC driver will try to use server-side-prepare on - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: CVS JDBC driver will try to use server-side-prepare on
Date
Msg-id 20030816003439.GD14392@opencloud.com
Whole thread Raw
In response to Re: CVS JDBC driver will try to use server-side-prepare on  (Barry Lind <blind@xythos.com>)
Responses Re: CVS JDBC driver will try to use server-side-prepare on
List pgsql-jdbc
On Fri, Aug 15, 2003 at 09:55:02AM -0700, Barry Lind wrote:

> But in short the reason is, that in general using the current
> prepared implementation will be *slower* than not using it, unless you
> are reusing the statement a number of times.  [...]

Hmm, has anyone considered an approach where the statement begins to use
server-side prepare after it has been used N times? (the assumption being
that it will continue to be reused). N=2 is probably enough to get 90% of
the cases :)

-O

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: CVS JDBC driver will try to use server-side-prepare on unpreparable SQL
Next
From: Oliver Jowett
Date:
Subject: patch: fix a couple of server-prepared-statement bugs