Re: [PATCHES] ECPG patch to use prepare for improved performance

2007-05-10 Thread William Lawrance
, 2007 3:01 AM To: William Lawrance Cc: Michael Meskes; Pgsql-Patches Subject: Re: [PATCHES] ECPG patch to use prepare for improved performance On Wed, May 09, 2007 at 01:12:17PM -0700, William Lawrance wrote: 2. The performance was improved by about 1 hour in the 3 hour elapsed time

Re: [PATCHES] ECPG patch to use prepare for improved performance

2007-05-09 Thread William Lawrance
applications. Is there reason not to prepare each statement? Could it be predicated upon a user supplied option ? Other comments ? -Original Message- From: Michael Meskes [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 09, 2007 2:04 AM To: William Lawrance Cc: Pgsql-Patches Subject: Re

[PATCHES] ECPG patch to use prepare for improved performance

2007-05-07 Thread William Lawrance
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. It was developed during the preparation for a benchmark for a large customer. This benchmark