[Zope-dev] zope2/zodb cache size question

[Jürgen Herrmann]

hi there!

today i ran a check script which iterates over approx 150000 objects
and does some sanity check calculations on these. during this loop
i saw the zope process use up to about 4.5gb memory. the database 
has ~3.5million objects in it.

i set the zodb cache size for the mount point in question to 10000
objects. obviously this limit is not honoured during one transaction:

connection                     active objects      total objects
...
<Connection at 24c10410>       263104              462834
...

so two questions here:
- would the byte-limited zodb cache setting help here?
- if no - how can i iterate over a big set of objects without
  forcing them to stay in the cache for the whole transaction?
  after all i just need each object once during the iteration.

thanks in advance and best regards,
jürgen herrmann
-- 
>> XLhost.de - eXperts in Linux hosting ® <<

XLhost.de GmbH
Jürgen Herrmann, Geschäftsführer
Boelckestrasse 21, 93051 Regensburg, Germany

Geschäftsführer: Volker Geith, Jürgen Herrmann
Registriert unter: HRB9918
Umsatzsteuer-Identifikationsnummer: DE245931218

Fon:  +49 (0)800 XLHOSTDE [0800 95467833]
Fax:  +49 (0)800 95467830

WEB:  http://www.XLhost.de
IRC:  #XLhost at irc.quakenet.org