My zope database is getting larger and close to 2GB, i want to figure out a way to handle it. First i want to find out how much space each directoy takes inside zope database. How can i find out that?
If the objects are fileish content then you could write a script which adds up their size (via the get_size method). This won't tell you exactly home much space it takes up in the ZODB, but it will tell you where most of the data is.
Something like this, which I use, in a method called 'du', which I just call on various folder objects: <dtml-in "PARENTS[0].objectValues()"> <dtml-var id> <dtml-if title> (<dtml-var title>)</dtml-if> <dtml-try><dtml-var getSize> <dtml-except>no size reported </dtml-try> <br /> </dtml-in> - John Maxwell jmax@sfu.ca