Re: Informix Performance on Two Ultrasparcs

kleckab@river.it.gvsu.edu (Mr. Nasty) wrote: :jason malaure (jmalaure@dial.pipex.com) wrote: :: I was wondering if anybody could shed some light on how well Informix :: Online 7 performs on a dual 200MHZ UltraSparc. I have been informed :: that it is SLOWER on two ultrasparcs than on one when Informix is setup :: to take advantage of them due to 'processing overhead'. : :We are finding out the same thing. We are running HP9000 with 2 processors :on HPUX 10.10. Informix 7.0 performs terrible. Informix support said :that the overhead of 'locking processors' will degrade performance. :They said to set the Database up as a 'single processor'. This have been discussed extensively before and different people have come to different conclusions. It's not conclusive that Informix will allways perform slower with 2 processors than with one. It seems to depend both on which hardware and OS you have as well as the other parts of your tuning of the engine. It seems that one have to test this out for each installation. 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