[ZODB-Dev] how big can a ZODB get?

[Victor Ng]

Thanks for the info Jim, where can I find information on ZODB tuning? 
I'm running ZODB 3.3 right now and I'm not sure where to start looking
for the 'knobs' I need to turn.   I found one reference to tuning the
ZODB from Jeremy Hylton from 2002 :

http://mail.zope.org/pipermail/zodb-dev/2002-November/003675.html

But that's about it.  Are there separate tuning docs when using the
ZEO with ZODB?  Where can I find information?

thanks,
vic


On Wed, 12 Jan 2005 07:22:32 -0500, Jim Fulton <jim at zope.com> wrote:
> Victor Ng wrote:
> > Has anyone tested to see how large a ZODB can get in terms of number of objects?
> 
> In theory, the number of objects is unlimited. IOW, there is
> no architectural limit.
> 
> > How much RAM should I expect to have to get acceptable performance for
> > a large number of objects, say somewhere around 200,000->1,000,000 ?
> 
> That depends on lots of factors. Unfortunately, you really need to see what
> works for your application.  The main consumer of memory (for that number of objects)
> is the in-memory object cache.  How big this gets depends on how you've tuned it
> and how you should tune it depends on your application's data structures and
> access patterns.
> 
> (Your question is a little bit like asking "How much RAM to I need to use
>   Python?" :)
> 
> > Can ZODB even grow that large?
> 
> Absolutely.
> 
> Jim
> 
> --
> Jim Fulton           mailto:jim at zope.com       Python Powered!
> CTO                  (540) 361-1714            http://www.python.org
> Zope Corporation     http://www.zope.com       http://www.zope.org
> 
>