[Zope] Tweaking Zope DB- and connection parameters

[J Cameron Cooper]

>>Apache is set to "MaxClients 50"
>>Zope.conf has set "zserver-threads 5" and 
>><zodb_db main>
>>   cache-size 500
>>   pool-size 25
>>...
>></zodb_db>

I will note that a cache-size of 500 is ridiculously low. (Even though 
old versions of Zope shipped configured like this!)

It needs to be at least 5000. Frankly, 50000 wouldn't be bad for a 
large, busy site.

To optimize your cache-size param, watch the ZODB read/write graph, and 
keep increasing the cache-size until (a) there's no more effect on reads 
or (b) you run into memory trouble.

Of course, the optimization will slip a little as site usage patterns 
change.

		--jcc
-- 
"Building Websites with Plone"
http://plonebook.packtpub.com/

Enfold Systems, LLC
http://www.enfoldsystems.com