Re: pooled prepared statements

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: pooled prepared statements
Дата
Msg-id 491f66a50905130821j6afa056fp947e4dbcfd09d701@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pooled prepared statements  ("John Lister" <john.lister@kickstone.com>)
Ответы Re: pooled prepared statements
Список 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 по дате отправления:

Предыдущее
От: "Vernon"
Дата:
Сообщение: [Fwd: Re: Enums - from java to jpa]
Следующее
От: Thomas Finneid
Дата:
Сообщение: Re: pooled prepared statements