Benchmark ZOBD compared to RDBMS
Hi, I'm searching for benchmark comparing ZODB to some RDBMS like Mysql. I know that both technologies are different but I'd like to know if we should expect some performance problem with ZODB used to store millions of objects. Thanks Simon
--On 9. August 2005 14:05:35 +0200 Simon ALEXANDRE <simon.alexandre@cetic.be> wrote:
Hi,
I'm searching for benchmark comparing ZODB to some RDBMS like Mysql. I know that both technologies are different but I'd like to know if we should expect some performance problem with ZODB used to store millions of objects.
As you said such a comparision makes no sense especially because there lots of RDBMS on the market that perform differently. A million object must not mean a million rows so you are really comparing cats with dogs. In general the ZODB is slower than a RDBMS (depending on what you are doing).. -aj
Simon ALEXANDRE schrieb:
Hi,
I’m searching for benchmark comparing ZODB to some RDBMS like Mysql. I know that both technologies are different but I’d like to know if we should expect some performance problem with ZODB used to store millions of objects.
I'd suggest to actually store your objects to find out. But storing is only half the work. Retrival and update, as well as schema extension, concurrency etc. are more interesting. Just storing means a plain mmapped file will sure outperform any RDBMS :-) And also see if you compare the actual interface speed, meaning if you plan a web application on top of your data, do the measurement on the resulting web app and not the bare storage.
--On 9. August 2005 16:44:56 +0200 Tino Wildenhain <tino@wildenhain.de> wrote:
I'd suggest to actually store your objects to find out. But storing is only half the work. Retrival and update, as well as schema extension, concurrency etc. are more interesting. Just storing means a plain mmapped file will sure outperform any RDBMS :-)
The basic question for choosing RDBMS over ZODB: do you have strong or weak relations between your data. The ZODB is good for dealing with objects that have no or weak relations to each other. If you have strong and complex relations between your data better use a RDBMS. SQL is perfect for dealing with such data...there is nothing similar you can do with Zope or the ZODB. -aj
participants (3)
-
Andreas Jung -
Simon ALEXANDRE -
Tino Wildenhain