[Zope-dev] how bad are per-request-write-transactions

[Casey Duncan]

This will kill performance, especially concurrent use of the site. It 
will also cause large amounts of database bloat. Do you need real time 
numbers, or is a delay (such as 24 hours) acceptable?

If you can stand a delay, another approach would be to write a script 
which scans the z2.log file (or another log that you generate on page 
hits) each night and in a single transaction updates a counter on each 
object hit.

If you use the z2.log, no additional writing is needed to the FS, and 
you get the benefit of easy access to the counts directly from the 
objects, without degrading performance or db bloat.

-Casey

Ivo van der Wijk wrote:
> Hi,
> 
> How bad are per-request transactions in a non-ZEO environment? I.e.
> each request on a folder or its subobjects will cause a write transaction
> (somewhat like a non-fs counter, but worse as it happens for all subobjects)
> 
> And if this is really bad, are there any workarounds except for writing
> to the filesystem?
> 
> Cheers
> 
> 	Ivo
> 
>