Re: BUFFERED LOGGING: Is it safe??

In article <42nskd$jfq@nezsdc.fujitsu.co.nz>, Steve Chell <steve@nezsdc.fujitsu.co.nz> wrote: >I'm trying to decide whether to use buffered or unbuffered logging >for a customer's database. The engine is Online 5.02.UC6. > >The Online Administrator's Guide says that "if you use buffered logging >and a failure occurs, you could lose more than just the current >transaction. In return for this risk, performance during alterations is >slightly improved." Does this mean that buffered logging carries with it >the risk that the fast-recovery mechanism might not be able to restore the >database to a consistent state in the event of a failure, or does it merely >mean that more transactions might be rolled back than otherwise would be? > >In other words, could buffered logging compromise the integrity of the >database in the event of a failure? I don't see how. Physical (fast) recovery will still work but all the transactions in the logical log buffer at the time of the failure, commited or not, will get rolled back. It only buffers the logical log, physical log buffering works as usual. -jrg -- internet jrg@galloway.sj.ca.us John R. Galloway, Jr 795 Beaver Creek Way applelink D3413 CEO...receptionist San Jose, CA 95133 Galloway Research (408) 259-2490 v (408) 259-5058 f