Re: Allow pooled connections to list all prepared queries

Поиск
Список
Период
Сортировка
От Kris Jurka
Тема Re: Allow pooled connections to list all prepared queries
Дата
Msg-id Pine.BSO.4.56.0412251859460.17812@leary.csoft.net
обсуждение исходный текст
Ответ на Allow pooled connections to list all prepared queries  (David Brown <dave@spoonguard.org>)
Ответы Re: Allow pooled connections to list all prepared queries  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Re: Allow pooled connections to list all prepared queries  (David Brown <dave@spoonguard.org>)
Список pgsql-patches

On Wed, 22 Dec 2004, David Brown wrote:

>     This would allow an application inheriting a pooled connection to know
>     the queries prepared in the current session.
>

I don't see this as all that helpful for a client interface that does the
preparation itself.  Possibly it could be used for libpq, but you
mentioned DBI which should already know what it has or has not prepared.
The idea of adding a network round trip to detect a prepared statement
seems like a performance loss, not a gain.  If this is just to avoid
repreparing the same statement then perhaps something like PREPARE OR
REPLACE would be more useful.

Kris Jurka

В списке pgsql-patches по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Allow pooled connections to list all prepared queries
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: Allow pooled connections to list all prepared queries