[Zope] Re: Too many ZODB object loads...

[Suresh V]

Dieter Maurer wrote:
> 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)?

We hiked it up to 60K per thread because we have lots of memory and 
wanted to make Zope perform better. Is there a disadvantage to this?

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

But even under very little site activity, it seems to be loading a lots 
of objects. Is this normal?

> 
>> ...
>> 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.
> 

Nope.

> 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.
>

I will check this.

Thanks for your pointers.

Suresh