On Tuesday 02 April 2002 07:16 am, Kevin Carlson wrote:
Casey,
I read this thread with some interest because I am facing a decision of a similar sort. I am a fan of putting all of the content of our site into the Zope DB but am meeting with skepticism from some. Since ZODB has the distinction of being an object database and several attempts at that technology in the past have met with less than optimum performance results as the database grew (think ObjectStore), a few people seem to think an Rdb would be better suited. I would really like to be able to provided them with some performance benchmarks related to ZODB. Do you have anything available that shows performance of the ZODB as the database grows to say 20GB or 100GB? Are there any available statistics related to the size of machine needed to support a large user community of say 10K with a database that size?
while i'm told there are databases of this size, i think it misses the point, namely that zope can very easily be used to integrate diverse data sources. as such a separation of data storage concerns from the application logic can be used such that where the content is stored should be a domain concern. ie take a popular message board store its contents in a rdbms, take some news releases store them in the zodb, use zope as the glue and the application logic to make things fit together. -k