Hi,<br><br>I wrote a simple script to move data from a ZODB database to sqlite. <br> My data is in a OOBTree, I chose this because supposedly you can bring the buckets to memory one at a time....<br><br>So what I am doing is basically this: I iterate over my objects and write them one-by-one to the other db.
<br>for k,u in user_root['userdb'].items(): # I have tried iteritems() here too but the results are the same....<br> # write the data to sqlite<br><br>My problem is that my database is big and as the memory consumption increases as the loop progresses until all my memory is exhauted and the OS goes into swap. It seems that the objects from previous iterations are not been cleared from memory.
<br>Am I doing something wrong, or is it impossible to iterate over a ZODB database which is bigger than you memory?<br><br>thanks,<br><br clear="all"><br>-- <br>Flávio Codeço Coelho<br>----------------------------------------------------------------
<br>"My grandfather once told me that there were two kinds of people: those who do the work and those who take the credit. He told me to try to be in the first group; there was much less competition."<br>Indira Gandhi
<br>====================================<br>registered Linux user # 386432<br>get counted at <a href="http://counter.li.org">http://counter.li.org</a><br>----------------------------------------------------------------