Re: how not to run out of memory in cursor.execute

2006-06-05 Thread amberite
[EMAIL PROTECTED] wrote: > I am using cx_Oracle and MySQLdb to pull a lot of data from some tables > and I find that the cursor.execute method uses a lot of memory that > never gets garbage collected. Using fetchmany instead of fetchall does > not seem to make any difference, since it's the execut

Re: how not to run out of memory in cursor.execute

2006-06-06 Thread amberite
Steve Holden wrote: > > The MySQLdb solution you give is way more complicated than it needs to > be, thereby skewing your opinion towards cx_Oracle unnecessarily. > I respectfully disagree with your assertion here. The code I presented for MySQLdb is what you *have* to do, to avoid using up too