Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id BD7EE63275E for ; Thu, 24 Jun 2010 09:18:58 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 24274-05; Thu, 24 Jun 2010 12:18:50 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.187]) by mail.postgresql.org (Postfix) with ESMTP id 852C4632624; Thu, 24 Jun 2010 09:18:51 -0300 (ADT) Received: from feivel (exit.credativ.com [87.139.82.80]) by mrelayeu.kundenserver.de (node=mrbap2) with ESMTP (Nemesis) id 0LeS5t-1Ozlfh0nGP-00qA6i; Thu, 24 Jun 2010 14:13:36 +0200 Received: by feivel (Postfix, from userid 1000) id 954FB10A807; Thu, 24 Jun 2010 14:13:35 +0200 (CEST) Date: Thu, 24 Jun 2010 14:13:35 +0200 From: Michael Meskes To: =?utf-8?B?QsO2c3rDtnJtw6lueWkgWm9sdMOhbg==?= Cc: Bruce Momjian , Michael Meskes , PG Hackers , Hans-Juergen Schoenig Subject: Re: ECPG FETCH readahead Message-ID: <20100624121335.GC24137@feivel.credativ.lan> Mail-Followup-To: =?utf-8?B?QsO2c3rDtnJtw6lueWkgWm9sdMOhbg==?= , Bruce Momjian , Michael Meskes , PG Hackers , Hans-Juergen Schoenig References: <201006232042.o5NKgb503695@momjian.us> <4C2308FD.1090300@cybertec.at> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: <4C2308FD.1090300@cybertec.at> User-Agent: Mutt/1.5.20 (2009-06-14) Content-Transfer-Encoding: quoted-printable X-Provags-ID: V01U2FsdGVkX198J/bF3Ygj+cUm/9/uDEnUx6nPfnLqPg58ITK 6aW6kUbFx2Blwsar1+aVeW09KJPaNX6I7Zxjy+B4wbtcXloxgY M7vYJjB10QI7zs/pY7dkg== X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.8 tagged_above=-5 required=5 tests=BAYES_50=0.8, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201006/1280 X-Sequence-Number: 164910 > I think, yes, it does make sense. Because we are talking > about porting a whole lot of COBOL applications. COBOL??? > 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 w= rote themselves, right? I simply refuse to add this stuff only to fix this sit= uation for that one customer of yours if it only hits them. Now the thing to dis= cuss is how common is this situation. Michael --=20 Michael Meskes Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org) Michael at BorussiaFan dot De, Meskes at (Debian|Postgresql) dot Org ICQ 179140304, AIM/Yahoo/Skype michaelmeskes, Jabber meskes@jabber.org VfL Borussia! For=C3=A7a Bar=C3=A7a! Go SF 49ers! Use Debian GNU/Linux, P= ostgreSQL