[sqlalchemy] mysql + query.execute memory usage

2009-11-18 Thread James Casbon
Hi, I'm using sqlalchemy to generate a query that returns lots of data. The trouble is, when calling query.execute() instead of returning the resultproxy straight away and allowing me to fetch data as I would like, query.execute blocks and the memory usage grows to gigabytes before getting killed

Re: [sqlalchemy] mysql + query.execute memory usage

2009-11-18 Thread Michael Bayer
On Nov 18, 2009, at 9:57 AM, James Casbon wrote: Hi, I'm using sqlalchemy to generate a query that returns lots of data. The trouble is, when calling query.execute() instead of returning the resultproxy straight away and allowing me to fetch data as I would like, query.execute blocks and