Hi,<br><br>great work! thanks!<br><br>I think it would be a good idea to update the wiki with instructions of how to enable RelStorage for use with Standalone ZODB. I am particularly interested in doing it. I am anxious to benchmark it too.... especially the packing time....<br>
<br><div class="gmail_quote">On Jan 30, 2008 6:38 AM, Shane Hathaway <<a href="mailto:shane@hathawaymix.org">shane@hathawaymix.org</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;">
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>Test #1: I measured the time to create a new database from scratch and<br>
start handling requests. I did this using a fresh instance of Zope<br>2.10.5 with Plone 3.0.5. The duration is from the time I started Zope<br>to the time Zope said "Ready to handle requests".<br><br> Test #1 on FileStorage: 24.9 seconds<br>
Test #1 on RelStorage/PostgreSQL: 23.1 seconds<br><br>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>Kudos to the PostgreSQL team for building such a nice database. :-)<br>
Oracle performance is up as well, I believe. Should I make a MySQL 5+<br>adapter? It could be fun.</blockquote><div><br>+1 <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><br>Instructions for checking out RelStorage are in the Wiki.<br><br> <a href="http://wiki.zope.org/ZODB/RelStorage" target="_blank">http://wiki.zope.org/ZODB/RelStorage</a><br><br>Shane<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></blockquote></div><br><br clear="all"><br>-- <br>Flávio Codeço Coelho<br>----------------------------------------------------------------<br>
"My grandfather once told me that there were two kinds of people: those who do the work and those who take the credit. He told me to try to be in the first group; there was much less competition."<br>Indira Gandhi<br>
====================================<br>registered Linux user # 386432<br>get counted at <a href="http://counter.li.org">http://counter.li.org</a><br>----------------------------------------------------------------