[Seaside] Re: Scaling Seaside apps (was: About SToR)

Richard Huxton dev at archonet.com
Thu Aug 3 08:40:55 UTC 2006

Yanni Chiu wrote:
> Having said that, unless you use cursors, the postgres
> driver will pull the entire result set into memory.
> This behaviour is an artifact of the communication protocol
> between the postgres server and a client process. However,
> the newer version 3 of this protocol does not pull in the
> entire data set. I'd be interested to know whether you can
> in fact avoid pulling in the entire data set by using cursors,
> with the current postgres driver (which implements version 2
> protocol).

I'm not sure this has changed in v3 of the protocol, PG has always 
returned all the rows you request. I certainly can't find any mention of 
it here:

As you say, cursors sound like the way to go.

   Richard Huxton
   Archonet Ltd

More information about the Seaside mailing list