[Zope] Large ZODB vs SQL + cataloging issues

Dieter Maurer dieter@handshake.de
Tue, 23 Jul 2002 23:37:30 +0200


Felix Ulrich-Oltean writes:
 > I am looking to build a system to hold 100s of sites, each of which
 > holds several catalogues (as in on-line shopping, not ZCatalogs).  How
 > large can ZODB realistically go?  At which point would it make more
 > sense to hold data in a n RDBMS and use sql from Zope instead?
Search for Toby's message (--> mailing list archives) about ZODB
memory characteristics.

 > Also, a related note is:  If I have 100 online shops running from my
 > Zope isntance, and one if them is a thousand times bigger than the
 > others, how will the ZCataloging and general traffic on the big site
 > affect the others?
Try it out!

In principle, access should be logarithmic (in the number of entries
in the index).


Dieter