Re: ECPG patch to use prepare for improved performance

Поиск
Список
Период
Сортировка
От Michael Meskes
Тема Re: ECPG patch to use prepare for improved performance
Дата
Msg-id 20070509090403.GB18105@feivel.credativ.de
обсуждение исходный текст
Ответ на ECPG patch to use prepare for improved performance  ("William Lawrance" <bill.lawrance@bull.com>)
Ответы Re: ECPG patch to use prepare for improved performance  ("William Lawrance" <bill.lawrance@bull.com>)
Список pgsql-patches
On Mon, May 07, 2007 at 02:46:29PM -0700, William Lawrance wrote:
> This patch for ECPG utilizes the "PQprepare" and "PQexecPrepared"
> functions to cause SQL statements from ECPG to be cached. It does
> this without requiring any changes in the user's source program.
> ...

I still do not understand why you prepare each statement. This might
help you with your test case, but I don't like to add this as a general
rule. If a user wants a prepared statement he/she should use the prepare
statement. I agree that the prepare logic has to be rewritten and this
is high on my agenda, but I will probably only do this for statements
issued with EXEC SQL PREPARE not for every single statement.

Michael
--
Michael Meskes
Email: Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org)
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes@jabber.org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: [WIP] GUC for temp_tablespaces
Следующее
От: Gregory Stark
Дата:
Сообщение: Doc and comment patch for packed varlena