I'm attempting to process through record sets from DAL queries that can
sometimes return hundreds of thousands of records. To try to keep memory
usage under control I wanted to use iterselect() instead of a plain DAL
select(). However, the problem I'm running into is that as I process each
record I need to perform other actions against the same database but when I
do so I get "Connection is busy with results for another command" because
of course I haven't finished getting all of the records yet. Is there some
simple way to deal with this? Seems like it'd be the norm to need to do
other things with the database while using iterselect().
I'm using a Microsoft SQL Server database with pyodbc. The DAL connection
is using mssql4n with {SQL Server Native Client 11.0} as an extra driver
argument.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
