Re: special thanks and informix performance considerations
<!doctype html public "-//w3c//dtd html 4.0 transitional//en"> <html> I took a look at the <i>onconfig</i> you attached. When you say you are <br>disappointed with the performance, what manner of testing did you <br>use ? Without an idea of your metrics, performance tuning is more a <br>shot in the dark as opposed to dealing with identified problem areas <br>and resolving these in an orderly manner. <p>I can state that (last I heard) you could not configure more than one <br>AIO VP on an NT system. This in itself can create a bottleneck <br>problem in terms of I/O. The <i>onconfig </i>I received showed NO entry <br>for AIO VPs, which defaults to one. <br>Configuration parameters that work efficiently on NT may not be <br>what works best on a unix based system like Linux. Try bumping <br>up the NUMAIOVPs to 1 per chunk or 2 per dbspace (opinions <br>vary on this, try both ?) to distribute the I/O. Also, try bumping up <br>CLEANERs to atleast one per chunk with a minimum of two. <p>have a nice day. <p>Diego wrote: <blockquote TYPE=CITE>Hi, <p>I would like to thank all of you who help me to set up informix ids 7.30UC7 <br>running on my linux system. (PII-350Mhz+128MB RAM). <p>I was very disappointed with the performance compared with a NT 4.0+ IDS <br>7.30TC5 on the same machine. Both running on the same hardware/cooked files <br>conf/database data, NT outperforms linux by far. I am using the default <br>onconfig, just changed number of buffers. I hope that major changes should <br>be made to my configuration, so any ideas are welcome. Please help quit <br>using Micro$oft NT. <p>Thanks id advance. <br>Regards. Diego Mezzera.</blockquote> </html>