Re: OnLine 7.13 performance problems - comments please?

Neil Truby <ntruby@netcomuk.co.uk> wrote: :My explanation to the users is that the machine, which consistently shows :0% idle CPU, is simply overwhelmed by the application (which is :bought-in, so we can't tune it). When one of our customers machine sometimes show 0% or near 0% idle time on the CPU, performance surley goes down the drain increasing the time sql commands need to execute many fold (for obvious reasons). :Any other comments, suggestions or :opinions would be gratefully received. :MULTIPROCESSOR 1 # 0 for single-processor, 1 for :multi-processor How many CPU's do you have? Normally you should have at least 4 to set multiprocessor to 1 and as I remember it you should then set the below number higer than 1. If you have less than 4 CPUs setting MULTIPROCESSOR to 0 might alleviate some of your CPU load and give better performance. :NUMCPUVPS 1 # Number of user (cpu) vps :SINGLE_CPU_VP 1 # If non-zero, limit number of cpu vps :to one Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org