Re: [Zope-dev] Effect of DB Writes on Performance

2003-01-16 Thread seb bacon
Writes are slower than reads, but the real bottleneck is likely to be 
your application, not the ZODB.  Commonly ZODB writes take place within 
a busy transaction, including catalog updates, transformations, etc.

Brian R Brinegar wrote:
Hello,

What effect do ZODB Writes have on Performance? We use Zope in an
environment where users are constantly updating and maintaining content
within the ZODB. Do these writes to the Database slow down overall
performance?



___
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
http://lists.zope.org/mailman/listinfo/zope-announce
http://lists.zope.org/mailman/listinfo/zope )


Re: [Zope-dev] Effect of DB Writes on Performance

2003-01-16 Thread Dieter Maurer
Brian R Brinegar wrote at 2003-1-15 16:37 -0500:
  What effect do ZODB Writes have on Performance? We use Zope in an
  environment where users are constantly updating and maintaining content
  within the ZODB. Do these writes to the Database slow down overall
  performance?
When you are using FileStorage (below ZODB) then each write will
append the modified object as a serialized bytestream to
the file. With a high write frequency, your storage file may
rapidly grow and may need to be packed frequently.

Moreover, the ZODB uses an optimistic conflict resolution policy.
Such a policy is only efficient when the conflict probability
is low.
With higher write frequency, the conflict probability tends to
increase...


Dieter

___
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope )



[Zope-dev] Effect of DB Writes on Performance

2003-01-15 Thread Brian R Brinegar
Hello,

What effect do ZODB Writes have on Performance? We use Zope in an
environment where users are constantly updating and maintaining content
within the ZODB. Do these writes to the Database slow down overall
performance?

-Brian


___
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope )