Re: CVS JDBC driver will try to use server-side-prepare on

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Barry Lind <blind(at)xythos(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: CVS JDBC driver will try to use server-side-prepare on
Date: 2003-08-16 00:34:39
Message-ID: 20030816003439.GD14392@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2003-08-16 05:33:16 patch: fix a couple of server-prepared-statement bugs
Previous Message Oliver Jowett 2003-08-16 00:32:25 Re: CVS JDBC driver will try to use server-side-prepare on unpreparable SQL