Re: psycopg2 & large result set

2007-05-25 Thread Paul Boddie
On 25 May, 11:16, Jon Clements <[EMAIL PROTECTED]> wrote: > > I'm using psycopg2 to retrieve results from a rather large query (it > returns 22m records); unsurprisingly this doesn't fit in memory all at > once. What I'd like to achieve is something similar to a .NET data > provider I have which al

Re: psycopg2 & large result set

2007-05-25 Thread Rob Wolfe
Jon Clements wrote: > Hi All. > > I'm using psycopg2 to retrieve results from a rather large query (it > returns 22m records); unsurprisingly this doesn't fit in memory all at > once. What I'd like to achieve is something similar to a .NET data > provider I have which allows you to set a 'FetchSiz

psycopg2 & large result set

2007-05-25 Thread Jon Clements
Hi All. I'm using psycopg2 to retrieve results from a rather large query (it returns 22m records); unsurprisingly this doesn't fit in memory all at once. What I'd like to achieve is something similar to a .NET data provider I have which allows you to set a 'FetchSize' property; it then retrieves '