Re: ECPG FETCH readahead

Поиск
Список
Период
Сортировка
От Böszörményi Zoltán
Тема Re: ECPG FETCH readahead
Дата
Msg-id 4C23596C.4080904@cybertec.at
обсуждение исходный текст
Ответ на Re: ECPG FETCH readahead  (Michael Meskes <meskes@postgresql.org>)
Список pgsql-hackers
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



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

Предыдущее
От: PostgreSQL - Hans-Jürgen Schönig
Дата:
Сообщение: Re: ECPG FETCH readahead
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: EOL is when?