Informix 5 SE performance tuning?

Posted in 2004

Brian Mills — Thu, 29 Apr 2004 17:35:33 +0100 — source: Usenet: comp.databases.informix

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

↪ replying to Brian Mills

Neil Truby — Thu, 29 Apr 2004 18:33:29 +0100 — source: Usenet: comp.databases.informix

"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? No, there aren't. Could you look at moving to OnLine on Linux? There are some great deals to be had for this product combination (which for some reason IBM are keeping quiet about). We recently migrated a UK client from SE on SCO to OnLine on Linux ..... -- Neil Truby t:01932 724027 Director m:07798 811708 Ardenta Limited e:neil.truby@ardenta.com

↪ replying to Brian Mills

Enor Mouspenis — Fri, 30 Apr 2004 00:13:51 +0100 — source: Usenet: comp.databases.informix

Brian Mills wrote: > 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). Am working much with SE for many year. Problem with perfomrance always fix with index. Not any index, only right index. -- Enor