Slow delete

[Stan Hoeppner]

Michael Monnerie put forth on 7/20/2010 6:04 AM:

> Can someone guess the exact problems that can happen with delayed 
> transaction on a crash?

The only real crash scenario difference, as I understand it, is that with
delayed logging enabled you'll potentially lose more data due to crash as more
is held memory resident with delayed logging enabled.  The characteristics of
the data loss are the same with and without this enabled, it's just
potentially more severe with delayed logging enabled.

If your systems are prone to power loss, hardware failures, or kernel panics,
I'd not enable delayed logging.  If your systems are rock solid, and you can
benefit from the minor decrease in file fragmentation and the increase in mass
file delete speed, then enable it.

-- 
Stan