Re: Buffered log Vs. Unbuffered Log Database

From: musman@my-deja.com > >Can anybody shed light on Buffered Log Databases vs. Unbuffered Log >Database? >How one would recommend Buffered log or unbuffered log database when >you are running with ERP and have 128-users accessing the database >having 20,000 tables or above. If you want performance, use buffered logging, if you want maximum resilience, use unbuffered logging. May I stick my head out above the parapet on this one: in most cases, if you do have some sort of failure that requires some sort of recovery or rollforward, you would probably do some sort of validation exercise to see whether any data had been lost. I therefore feel that the extra performance you get out of buffered logging justifies its use in most cases. I'm probably alone in this. :-) ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

Obnoxio The Clown wrote in message <80gr4d$flt$1@news.xmission.com>... >May I stick my head out above the parapet on this one: in most cases, if you >do have some sort of failure that requires some sort of recovery or >rollforward, you would probably do some sort of validation exercise to see >whether any data had been lost. I therefore feel that the extra performance >you get out of buffered logging justifies its use in most cases And what if you do have some sort of failure and rely upon automatic "fast" recovery? Neil