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