Re: [ZODB-Dev] Understanding the ZODB cache-size option

2010-03-23 Thread Marius Gedminas
On Tue, Mar 23, 2010 at 01:57:50PM -0400, Jim Fulton wrote: > Some notes: > > - The Python profiler (cProfile) can help analyze object loading, > especially if you have good profiler analysis tools. Unfortunately, > I'm not aware of one that's included with Python. My nutty > pstats2html script,

Re: [ZODB-Dev] Understanding the ZODB cache-size option

2010-03-23 Thread Jim Fulton
On Mon, Mar 22, 2010 at 2:05 PM, Jeff Shell wrote: > Are there any metrics about how to set the ZODB 'cache-size' (or > cache-size-bytes) option? We've been using '5000' (arbitrarily chosen) for > our Zope 3.4-ish app servers. We have access to zc.z3monitor which can output > the "number of obj

Re: [ZODB-Dev] Understanding the ZODB cache-size option

2010-03-23 Thread Jim Fulton
On Tue, Mar 23, 2010 at 7:17 AM, Adam GROSZER wrote: > Hello, > > On top of that, be aware that those numbers 'cache-size' (or > cache-size-bytes) are for each connection. By default a Z3 ZODB can > have up to 7 connections in the pool. That means you might easily end > with 7 times the cache size

Re: [ZODB-Dev] Understanding the ZODB cache-size option

2010-03-23 Thread Adam GROSZER
Hello, On top of that, be aware that those numbers 'cache-size' (or cache-size-bytes) are for each connection. By default a Z3 ZODB can have up to 7 connections in the pool. That means you might easily end with 7 times the cache size set. Most people tend to limit the number of connections too.