RE: Informix UC7.41 - slow

> -----Original Message----- > From: Obnoxio The Chav [mailto:obnoxio@serendipita.com] > Sent: Monday, January 17, 2005 1:06 PM > To: Everett Mills > Cc: informix-list@iiug.org > Subject: RE: Informix UC7.41 - slow > > > Everett Mills said: > > > > 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. > > Unless of course he's running on AIX... :o( > Unfortunately true. His Sun Blade should be running Solaris (if memory serves), so he should be OK with it. Also, he said it was a two way system (2 x 750Mhz), so should he do something like this: MULTIPROCESSOR 1 # 0 for single-processor, 1 formulti-processor NUMCPUVPS 2 # Number of user (cpu) vps SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vpsto one Instead of: MULTIPROCESSOR 0 # 0 for single-processor, 1 formulti-processor NUMCPUVPS 1 # Number of user (cpu) vps SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vpsto one Or if he's got a one processor license: MULTIPROCESSOR 1 # 0 for single-processor, 1 formulti-processor NUMCPUVPS 1 # Number of user (cpu) vps SINGLE_CPU_VP 1 # If non-zero, limit number of cpu vpsto one Just a thought --EEM sending to informix-list