[ZODB-Dev] Speedy RelStorage/PostgreSQL

Andreas Jung lists at zopyx.com
Wed Jan 30 04:06:29 EST 2008



--On 30. Januar 2008 01:38:17 -0700 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 #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.

You're system is appearently very slow. Tested the same myself on an
Opteron system (2.6 GHz) against a remote Postgres 8.1 DB...takes
roughly 5-6 seconds and is basically as fast a FileStorage...great!

Andreas
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 194 bytes
Desc: not available
Url : http://mail.zope.org/pipermail/zodb-dev/attachments/20080130/ccc7f8a8/attachment.bin


More information about the ZODB-Dev mailing list