Re: Informix 5 SE performance tuning?

There are things you could look at doing. What about UPDATE STATISTICS? Is that being run regularly? Other respondents suggested looking at indexes. I would also suggest looking at the location of the tables. Are there any tables that have high access rates. You could think about splitting these onto separate physical drives to share the disk load. But the most important thing you need to determine is what is holding things up. Are you disk, memory, or processor bound? Once you know that you can think about moving forward. And where did you get the software from? Who developed the application? I should talk to them for help in the first instance. regards Malcolm "Brian Mills" <brianmills@idontthinkyouunderstandspamprotection.co.uk> wrote in message news:<3MmdnS8AFYZ5swzdRVn-jg@nildram.net>... > Hi > > I know Informix 5 SE is OLD but it is our platform for the forseeable > future. I have just massively increased the throughput of our SCO server > running this by way of adjucting the NBUF and NHBUF parameters in the > kernel. Are there any Informix specific parameters I can play with to see if > I can get even more from this aeging but solid and important database? Web > links or howto's would be very much appreciated. We have 512MB RAM (about > 240 unused) on a P3 1Gig Proliant ML370. I have already flashed the firmware > on the RAID card giving around 30% a month ago more but the NBUF has just > doubled performance on top (and more in some cases where the same table is > hammered). > > Thanks > Millsey