[sqlalchemy] Re: MemoryError in unitofwork.py

2007-04-27 Thread Brandon Goldfedder

Okay - next dump quesion: How do I clear out the objects in a session
that I no longer need to reference (in this case all of them)... Will
python GC take care of this?

--Brandon

On Apr 25, 7:15 am, Michael Bayer [EMAIL PROTECTED] wrote:
 On Apr 24, 2007, at 10:59 AM,BrandonGoldfedder wrote:



  I'm doing a fair number of session flushes as I update my data in the
  database. After about 53 of them (or so) I am getting the following
  exception:

File build\bdist.win32\egg\sqlalchemy\orm\session.py, line 294, in
  flush
File build\bdist.win32\egg\sqlalchemy\orm\unitofwork.py, line 181,
  in flush
  MemoryError

  Anyone have any ideas:
  My code is simply adding new entries and every 1000 entries flushing
  the objectstore.

 the session doesnt clear itself out after a flush, so with each  
 successive save() of objects memory will grow.


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---



[sqlalchemy] Re: MemoryError in unitofwork.py

2007-04-25 Thread Michael Bayer


On Apr 24, 2007, at 10:59 AM, Brandon Goldfedder wrote:


 I'm doing a fair number of session flushes as I update my data in the
 database. After about 53 of them (or so) I am getting the following
 exception:

   File build\bdist.win32\egg\sqlalchemy\orm\session.py, line 294, in
 flush
   File build\bdist.win32\egg\sqlalchemy\orm\unitofwork.py, line 181,
 in flush
 MemoryError

 Anyone have any ideas:
 My code is simply adding new entries and every 1000 entries flushing
 the objectstore.

the session doesnt clear itself out after a flush, so with each  
successive save() of objects memory will grow.

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---