Re: pooled prepared statements - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: pooled prepared statements
Date
Msg-id 491f66a50905130821j6afa056fp947e4dbcfd09d701@mail.gmail.com
Whole thread Raw
In response to Re: pooled prepared statements  ("John Lister" <john.lister@kickstone.com>)
Responses Re: pooled prepared statements  (Thomas Finneid <tfinneid@fcon.no>)
List pgsql-jdbc


On Wed, May 13, 2009 at 10:37 AM, John Lister <john.lister@kickstone.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.

pgsql-jdbc by date:

Previous
From: "Vernon"
Date:
Subject: [Fwd: Re: Enums - from java to jpa]
Next
From: Thomas Finneid
Date:
Subject: Re: pooled prepared statements