--On 23. Januar 2008 18:17:18 +0100 Andreas Jung <[EMAIL PROTECTED]> wrote:

--On 22. Januar 2008 21:17:45 -0500 Stephan Richter

On Tuesday 22 January 2008, Dieter Maurer wrote:
"OracleStorage" was abandoned because it was almost an order
or magnitude slower than "FileStorage".

Actually, Lovely Systems uses PGStorage because it is faster for them.

It would be interesting where PGS is faster than filestorage. Ok, I just
tried made a simple benchmark for testing write performance. I created a
Plone site and then created a copy using copy/paste within the ZMI.
(AMD Dualcore 2.6 GHz, Postgres 7.4.7 running on dedicated DB server):

Copy&Paste using Filestorage: 3-4 seconds
Copy&Paste using PGStorage: 30-40 seconds

Alan asked me to so some further testing. I wrote a small script
creating 100 Documents within one transaction (both in CMF and Plone)
and I calculated the transaction time (not included the overhead
for creating the instances)...the numbers are pretty much the self-speaking:

                  CMF                Plone
PGStorage        10-12 secs           15-18 secs
Filestorage      0.3-0.4 secs         0.4-0.6 secs


Attachment: pgpgsqD451uSw.pgp
Description: PGP signature

For more information about ZODB, see the ZODB Wiki:

ZODB-Dev mailing list  -  ZODB-Dev@zope.org

Reply via email to