[Zope] Too many ZODB object loads...

[Dieter Maurer]

Suresh V wrote at 2006-12-21 22:09 +0530:
>On the database Activity tab in the Control Panel, I am seeing a high
>number of Object Loads (400K per hour). My cache size if 60K from what I 
>see in the Cache Parameters tab, each of the 4 threads is well within 
>this limit.

60 k is unusually large. Are you sure that this is not the
combined size of all caches (such that each cache has a capacity
of 15 k)?

When the ZODB reported that it has read some number of objects,
it is very likely that it did indeed.

> ...
>The symptom is that Zope appears slow when adding/editing content.

Do you use text indexing? with ranking information?

The usual cosine (OKAPI) ranking requires a large amount of data.

When you perform modifications, usually the problem is not
the amount of objects read but the amount and size of
objects written. Use "fsdump" to determine the size of your
transactions.



-- 
Dieter