Re: Logical log write volumes

> Piggy-back COMMITs are a real event. All this means is that the logical > log buffer in shared memory is flushed to disk periodically. If a > second commit occurs before the log buffer is flushed it will continue > flushing the log buffer to disk. This does not alter the amount of data > written to the log, Ah, I see where I'm going wrong. I thought there was some mechanism whereby, if the same page got modified twice between log buffer flushes, Online would only write the one log record. I guess that's impossible because the logs need to keep a record of the state of every page / row at each stage of the game. akent@cix.compulink.co.uk (Andy Kent) ------------------------------------------------ Freelance Informix Database Specialist, Redland, Bristol, England