Re: To log or not to log, that is the question.
Posted in 1996
At 12:21 AM 3/1/96 GMT, Malcolm Weallans wrote: >I cannot believe what I am reading. REASONABLY SECURE!!! That's like >saying I've put a lock on my house and put the key under the mat. That's >reasonably secure. In the database world I don't believe nay of us can >accept being "reasonably secure". We need to be totally secure or >totally insecure. At least then we know where we stand! There is only >one use for BUFFERED LOGGING - to win benchmarks - nothing more!!! Time to get back onto the decaffinated coffee, Malcolm. :-) I understand your observations, and, in general, agree. However, if your client is not running a serious OLTP app, and isn't overly worried about the potential loss of 5 minutes worth of data, then they may consider it acceptable. I must add, however, that I always advise people to go unbuffered if they _are_ worried about data integrity... -- Cheers, Billy. ----------------------------------------------------------------------------- billy.wheeler@pixie.co.za +27 11 803 2151 p.o. box 3463, rivonia, rsa, 2128 +27 83 250 2324 i'm schizophrenic: my opinions are not those of me -----------------------------------------------------------------------------