Re: take long time to complete checkpoint

Posted in 2000

Obnoxio The Clown — Fri, 08 Dec 2000 14:35:35 -0000 — source: Informix-list mailing list archive (1991-1998)

From: Thanh Ngo <t-ngo@ti.com> > >'online.log' shows me that it took about 77 seconds to complete a >checkpoint. >It is not like our other database >engines, it only took about 3 or 5 second to complete the checkpoint. Can >someone tell me how to lower the time >for this? Increasing LRUS can help? We have Informix version 7.31.UC5. I'd guess your server just did a lot of work, like (for instance) a massive data load or update? Increasing CLEANERS and LRUS can help, as can decreasing your buffers or checkpoint interval or shrinking your physical log. Be aware that any of them could have other side effects, though. _____________________________________________________________________________________ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com