<br><br><div class="gmail_quote">On Jan 30, 2008 10:06 AM, Andreas Jung <<a href="mailto:lists@zopyx.com">lists@zopyx.com</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br><br>--On 30. Januar 2008 01:38:17 -0700 Shane Hathaway <<a href="mailto:shane@hathawaymix.org">shane@hathawaymix.org</a>><br>wrote:<br><div class="Ih2E3d"><br>> Hi guys,<br>><br>> I just committed some performance enhancements to RelStorage, then I<br>
> performed two simple speed comparisons with FileStorage using a<br>> stopwatch. I was surprised at the results.<br>><br>><br>><br></div><div class="Ih2E3d">> Test #2: I measured the time to create a Plone site in a new database.<br>
> The duration is from the time I clicked "Add Plone Site" to the time the<br>> Zope management interface reappeared.<br>><br>> Test #2 on FileStorage: 11.8 seconds<br>> Test #2 on RelStorage/PostgreSQL: 9.1 seconds<br>
><br>> I did this on a Linux 64 bit dual core system with PostgreSQL 8.2.6<br>> running locally.<br><br></div>You're system is appearently very slow. Tested the same myself on an<br>Opteron system (2.6 GHz) against a remote Postgres 8.1 DB...takes<br>
roughly 5-6 seconds and is basically as fast a FileStorage...great!</blockquote><div><br>In my understanding, the Relstorage version is faster than the FileStorage when the database has a lot of data.<br><br>What would be interesting imho is to evaluate when switching from FileStorage to RelStorage<br>
is interesting in terms of speed up (packing, zope usage, ..), so I would know for which customer I would switch to postgres for instance.<br><br>Another point is about windows: I would love to see the same benchmarks on such OS.<br>
<br>++<br>Tarek<br><br> <br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br><font color="#888888"><br>Andreas<br></font><br>_______________________________________________<br>
For more information about ZODB, see the ZODB Wiki:<br><a href="http://www.zope.org/Wikis/ZODB/" target="_blank">http://www.zope.org/Wikis/ZODB/</a><br><br>ZODB-Dev mailing list - <a href="mailto:ZODB-Dev@zope.org">ZODB-Dev@zope.org</a><br>
<a href="http://mail.zope.org/mailman/listinfo/zodb-dev" target="_blank">http://mail.zope.org/mailman/listinfo/zodb-dev</a><br><br></blockquote></div><br><br clear="all"><br>-- <br>Tarek Ziadé | Association AfPy | <a href="http://www.afpy.org">www.afpy.org</a><br>
Blog FR | <a href="http://programmation-python.org">http://programmation-python.org</a><br>Blog EN | <a href="http://tarekziade.wordpress.com/">http://tarekziade.wordpress.com/</a>