Re: Thoughts on Logical Log use requested

Posted in 2006

Obnoxio The Clown — Fri, 17 Mar 2006 15:23:35 -0000 (GMT) — source: Usenet: comp.databases.informix

Colin Dawson said: > i did that well before i asked the question. > > FYI (from the FM) > It is recommended that you set LOGBUFF to 16 or 32 kilobytes, or perhaps > 64 kilobytes for heavy workloads. The buffer gets flushed. The WHOLE buffer gets flushed. If the buffer is empty (as in your case), it flushes 32 pages, even though only one of them is full. It *is* in the manual. Somewhere. >>From: "Obnoxio The Clown" <obnoxio@serendipita.com> >> >>Colin Dawson said: >> > Surely whenever data is written to the log >> > it >> > does not write the unused portion of log buffer? >> >>RTFM. -- Bye now, Obnoxio "It's easier with pictures." -- Cosmo "But wait, it gets worse." -- Cosmo "Run, don't walk, for the nearest exit." -- Cosmo