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

[Richard Huxton]

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:
   http://www.postgresql.org/docs/8.1/static/protocol-changes.html

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

-- 
   Richard Huxton
   Archonet Ltd