Re: Slow system ?! - using Informix 7.x on Sun Sparc 1000

George Kydes (gkydes@ix.netcom.com) wrote: : Hi, : My company has a customer which is running our app (uses informix for : RDBMS) on a Sparc 1000. The system has the following specs: <snip> : Also, are there any other ways to reduce the amount of time it takes to : perform a checkpoint? Gauging from other systems that even have higher : volume, a checkpoint should only take a couple of seconds! Try reducing the values of the LRU_MAX_DIRTY and the LRU_MIN_DIRTY params down to about 15 & 10 and upping the checkpoint interval to about 1200. This will cause the page cleaners to clean the buffers more often and more thoroughly and leave less work for the checkpoint to do. : Any ideas would be appreciated. Joe -- --------------------------------------------------------------------------- Joe Lumbley(jlumbley@netcom.com) ---------------------------------------------------------------------------