Re: Bug(?) with cursors using aggregate functions.

From: Benjamin Scherrey <scherrey(at)proteus-tech(dot)com>
To: gearond(at)cvc(dot)net, PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Bug(?) with cursors using aggregate functions.
Date: 2003-04-29 15:23:44
Message-ID: HD3QOC7FEEWU21GAZT83907KI5ZIG.3eae9900@bonzoii
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Actually I'm using pyPgSQL. How does ASODB do this? Does it know some lower-level calls to
determine absolute position or just it just cache ALL results from the query up front? If the former,
then I'd like to know how they do it and perhaps I can implement this for pyPgSQL.

thanx & later,

Ben Scherrey

4/29/2003 11:04:47 AM, Dennis Gearon <gearond(at)cvc(dot)net> wrote:

>If you are using PHP, the ADODB library will do caching of results on the server file system and
allow you to 'cursor' through it. Of course, if you need requerying, you'd have to trigger that and pay
the time penalty.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gerhard Hintermayer 2003-04-29 15:44:04 Re: Backend memory leakage when inserting
Previous Message Richard Huxton 2003-04-29 15:18:48 Re: Importing from Access 2000?