RE: Physical Logging performance

Posted in 2003

R��diger M��hl — 29 Aug 2003 07:29:39 GMT — source: Usenet: comp.databases.informix

"Simmons, Keith" <keith.simmons@office2office.biz> wrote: > Yes, this is something I have tried to achieve, it tends to reduce > disk I/O to the Physical Log and make the I/O more efficient. I'm > currently running a PHYSBUFF of 512 (just so you don't get afraid of > big numbers!). The same can be applied to the LOGBUFF parameter as > well Thanks, Keith. Yes, I was afraid of big numbers, because the Admin Guide speaks of 32 for normal and 64 for heavy workload. You have perhaps also defined a high number of buffers? Ruediger