logo       

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

db.postgresql.jdbc

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



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




---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster



<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

News | FAQ | advertise