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

[Jim Fulton]

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