Re: [Zope] Benchmark ZOBD compared to RDBMS
--On 9. August 2005 16:44:56 +0200 Tino Wildenhain <[EMAIL PROTECTED]> 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 pgpxnPH2RqNgk.pgp Description: PGP signature ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Benchmark ZOBD compared to RDBMS
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. ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Benchmark ZOBD compared to RDBMS
--On 9. August 2005 14:05:35 +0200 Simon ALEXANDRE <[EMAIL PROTECTED]> 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 pgpiDByahhsBR.pgp Description: PGP signature ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] 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 ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
