[ZODB-Dev] Speedy RelStorage/PostgreSQL

[Flavio Coelho]

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 <shane at hathawaymix.org> 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 at 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
----------------------------------------------------------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.zope.org/pipermail/zodb-dev/attachments/20080130/abf41dc5/attachment.htm