Re: ECPG patch to use prepare for improved performance - Mailing list pgsql-patches

From Michael Meskes
Subject Re: ECPG patch to use prepare for improved performance
Date
Msg-id 20070509090403.GB18105@feivel.credativ.de
Whole thread Raw
In response to ECPG patch to use prepare for improved performance  ("William Lawrance" <bill.lawrance@bull.com>)
Responses Re: ECPG patch to use prepare for improved performance  ("William Lawrance" <bill.lawrance@bull.com>)
List 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 by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [WIP] GUC for temp_tablespaces
Next
From: Gregory Stark
Date:
Subject: Doc and comment patch for packed varlena