[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