From: Böszörményi Zoltán <zb@cybertec.at>
To: Michael Meskes <meskes@postgresql.org>
Cc: Bruce Momjian <bruce@momjian.us>
Cc: PG Hackers <pgsql-hackers@postgresql.org>
Cc: Hans-Juergen Schoenig <hs@cybertec.at>
Subject: Re: ECPG FETCH readahead
Date: Thu, 24 Jun 2010 15:11:08 +0200
Message-ID: <4C23596C.4080904@cybertec.at> (raw)
In-Reply-To: <20100624121335.GC24137@feivel.credativ.lan>
References: <201006232042.o5NKgb503695@momjian.us>
<4C2308FD.1090300@cybertec.at>
<20100624121335.GC24137@feivel.credativ.lan>
2010-06-24 14:13 keltezéssel, Michael Meskes írta:
>> I think, yes, it does make sense. Because we are talking
>> about porting a whole lot of COBOL applications.
>>
> COBOL???
>
Yes, OpenCOBOL...
>> The ESQL/C or ECPG connector was already written
>> the Informix quirks in mind, so it fetches only one record
>> at a time passing it to the application. And similar performance
>> is expected from ECPG - which excpectation is not fulfilled
>> currently because libecpg doesn't do the same caching as
>> ESQL/C does.
>>
> Eh, you are talking about a program you wrote for your customer or they wrote
> themselves, right? I simply refuse to add this stuff only to fix this situation
> for that one customer of yours if it only hits them. Now the thing to discuss
> is how common is this situation.
>
The OpenCOBOL database connector was written by them
but the problem is more generic. There are many "naive"
applications (elsewhere, too) using cursors but fetching
one record at a time perhaps for portability reasons.
This patch provides a big performance boost for those.
Best regards,
Zoltán Böszörményi
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: zb@cybertec.at, meskes@postgresql.org, bruce@momjian.us, hs@cybertec.at
Subject: Re: ECPG FETCH readahead
In-Reply-To: <4C23596C.4080904@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox