Re: Server-side cursors in psycopg2

2007-03-14 Thread Paul Boddie
On 14 Mar, 08:51, Malcolm Tredinnick <[EMAIL PROTECTED]> wrote: > > I hadn't realised that existing cursors pulled everything over at once > -- I would have "guessed" (based on no information other than "that's > the way I would think of doing it") that they would pull a chunk of > results each ti

Re: Server-side cursors in psycopg2

2007-03-13 Thread Malcolm Tredinnick
Hey Jeremy, On Mon, 2007-03-12 at 23:15 -0500, Jeremy Dunck wrote: > Over on the psycopg2 list, I saw a mention that psycopg2 supports > optional server-side cursors, which is good for client-side memory > usage but requires more network round-trips to fetch the whole > resultset. (Apparently, b

Server-side cursors in psycopg2

2007-03-12 Thread Jeremy Dunck
Over on the psycopg2 list, I saw a mention that psycopg2 supports optional server-side cursors, which is good for client-side memory usage but requires more network round-trips to fetch the whole resultset. (Apparently, by default, it fetches all results into the client process on the first fetch