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

From Barry Lind
Subject Re: CVS JDBC driver will try to use server-side-prepare on
Date
Msg-id 3F442107.3080908@xythos.com
Whole thread Raw
In response to Re: CVS JDBC driver will try to use server-side-prepare on  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc

Oliver Jowett wrote:
> 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 :)
>

I agree that this would likely work quite well.  If you use it more than
once you are likely to use it again.

--Barry




pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: FETCH and MOVE
Next
From: Barry Lind
Date:
Subject: Re: CVS JDBC driver will try to use server-side-prepare on