psycopg2 and large queries

[Steve Holden]

Paul Boddie wrote:

[...]>
> You really don't want to be traversing large data sets using fetchone,
> anyway. My approach (using pyPgSQL) involves fetchmany and then
> looping over each batch of results, if I really have to process the
> data in Python; most of the time I can do the processing in the
> database itself.

Hmm, pypgsql doesn't provide a 2.5 Windows installer. I take it you
aren't a Windows user ... ?

regards
 Steve
-- 
Steve Holden        +1 571 484 6266   +1 800 494 3119
Holden Web LLC              http://www.holdenweb.com/