Hi, great work! thanks!
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.... On Jan 30, 2008 6:38 AM, Shane Hathaway <[EMAIL PROTECTED]> wrote: > Hi guys, > > I just committed some performance enhancements to RelStorage, then I > performed two simple speed comparisons with FileStorage using a > stopwatch. I was surprised at the results. > > Test #1: I measured the time to create a new database from scratch and > start handling requests. I did this using a fresh instance of Zope > 2.10.5 with Plone 3.0.5. The duration is from the time I started Zope > to the time Zope said "Ready to handle requests". > > Test #1 on FileStorage: 24.9 seconds > Test #1 on RelStorage/PostgreSQL: 23.1 seconds > > Test #2: I measured the time to create a Plone site in a new database. > The duration is from the time I clicked "Add Plone Site" to the time the > Zope management interface reappeared. > > Test #2 on FileStorage: 11.8 seconds > Test #2 on RelStorage/PostgreSQL: 9.1 seconds > > I did this on a Linux 64 bit dual core system with PostgreSQL 8.2.6 > running locally. > > Kudos to the PostgreSQL team for building such a nice database. :-) > Oracle performance is up as well, I believe. Should I make a MySQL 5+ > adapter? It could be fun. +1 > > > Instructions for checking out RelStorage are in the Wiki. > > http://wiki.zope.org/ZODB/RelStorage > > Shane > _______________________________________________ > For more information about ZODB, see the ZODB Wiki: > http://www.zope.org/Wikis/ZODB/ > > ZODB-Dev mailing list - ZODB-Dev@zope.org > http://mail.zope.org/mailman/listinfo/zodb-dev > -- Flávio Codeço Coelho ---------------------------------------------------------------- "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." Indira Gandhi ==================================== registered Linux user # 386432 get counted at http://counter.li.org ----------------------------------------------------------------
_______________________________________________ For more information about ZODB, see the ZODB Wiki: http://www.zope.org/Wikis/ZODB/ ZODB-Dev mailing list - ZODB-Dev@zope.org http://mail.zope.org/mailman/listinfo/zodb-dev