Thread: [SQLObject] problem clearing the cache
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: sophana <so...@zi...> - 2008-08-19 21:07:49
|
Hi I need to iterate over all the rows to check something. When doing this, I saw memory consumption raising infinitely. Then I remembered that sqlobjects caches everything. Then I tried: for a in SOClass.select(): connection.cache.clear() memory is still growing. Is it a python problem or a SQLObject problem? What do you suggest for this? Thanks |
From: Oleg B. <ph...@ph...> - 2008-08-19 21:17:11
|
On Tue, Aug 19, 2008 at 11:07:40PM +0200, sophana wrote: > I need to iterate over all the rows to check something. > When doing this, I saw memory consumption raising infinitely. > Then I remembered that sqlobjects caches everything. > Then I tried: > > for a in SOClass.select(): > connection.cache.clear() > > memory is still growing. > Is it a python problem or a SQLObject problem? > What do you suggest for this? .select() (SelectResult.__iter__, actually) draws all rows into one huge list. Try for a in SOClass.select().lazyIter(): ... Oleg. -- Oleg Broytmann http://phd.pp.ru/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |