Re: Checkpoint duration

Posted in 2000

Don Ignacio — Fri, 23 Jun 2000 14:30:47 -0400 — source: Informix-list mailing list archive (1991-1998)

Lower the LRU_MAX_DIRTY and LRU_MIN_DIRTY so that LRU writes will occur more frequently. The only trade-off is that you'll incur more disk i/o, but sessions will not wait. Unlike checkpoints which basically blocks sessions from entering critical section. DOn "Farmer, Byrd G - CFC" wrote: > > I am having an issue with checkpoints taking an extremely long time > during data loading. Normally during the day the checkpoints last 0 > to 1 seconds, but when loading data, the checkpoint duration goes up > to 30 to 80 seconds. Would increasing the physical log file help in > this at all? I am using 7.24 UC3 and using Informatica as my ETL > tool.