Re: pooled prepared statements

Maybe your right. The query processing takes from 1-10 seconds, so
planning it is not a big factor. But when the load becomes higher, as it
will be as the data increases, the planning might possibly eat time
which could be used elsewhere.

My server, as it is now, is pushing the limits of postgres for my use,
so maybe I need to reclaim as much of wasted time as possible...

We'll see.

thomas

Dave Cramer wrote:
>
>
> On Wed, May 13, 2009 at 10:37 AM, John Lister <john(dot)lister(at)kickstone(dot)com
> <mailto:john(dot)lister(at)kickstone(dot)com>> wrote:
>
> Probably easier to create a server side function
> instead, then.
>
> But wouldn't you still have to go through all the planning
> steps within the function for any queries, although i'll
> admit i'm not familiar with Postgresql functions.
>
>
> Server-side functions are compiled when installed. Since my
> function would only contain simple queries that are
> parameterized, it would pre-compile well.
>
>
> While the function may be compiled, the overhead is the same for
> preparing the statement inside the function. So I don't think it's a
> huge win.
>