Re: On-Line 7 Performance

Neil Truby wrote: > > I would broadly endorse your settings, although I have my logs, phys and > logical, in one dbspace. > > I'm interested in your having RESIDENT set to 0. Informix Tech Support > recommended to me that it should be set to 1 if it has no significant > effect on the paging rate. > > What are your, and others' experiences? > > Neil Truby > Chase Manhattan Bank > Bournemouth, UK Some Operating systems (or machines) seem to not support the setting RESIDENT 1. At least SCO OS 5.0.1 complains, if setting RESIDENT to 1. I could nout find any information about this in the manuals. IMHO RESIDENT 1 should improve performance by some degree, since often used data will stay in Shared Memory all time. Regards, Kai Shen