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 for too much memory. This looks to me like execute is prefetching the entire result.
Is there any way to prevent query.execute loading the entire result? Thanks, James -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=.
