Re: On-Line 7 Performance

Kai Shen wrote: > > Neil Truby wrote: > > > 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? > > 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. Yes, but not if the application is being swapped out. :-) You are right, some platforms do not have this capability. Read the release notes for more info. I always set RESIDENT=0 unless there is loads of memory available, or when setting up a database server, with no other applications running. Cheers, -- Mark. +------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto:marks@west.co.za +-----------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work, force it! | |Fax: +27 11 803 2189 |If it breaks, it needed replacing anyway!| |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+-----------------------------------------+