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@irc.quakenet.org