RE: Informix UC7.41 - slow

Posted in 2005

Everett Mills — Mon, 17 Jan 2005 12:37:28 -0600 — source: Usenet: comp.databases.informix

Geezer- I don't get why you cleared out your stats, but one thing I noticed is this: > RESIDENT 0 # Forced residency flag (Yes = 1, No = 0) If your engine is being swapped out of memory, it will dump the performance of the engine and all of the applications attaching to it into the toilet. You may want to consider this: RESIDENT -1 This will not allow any segments of your engine to be paged out of memory. --EEM sending to informix-list