Re: MULTIPROCESSOR Flag and poor CPU Allocation

> Dick Counsell <dickc@wrq.com> writes: > ... deleted ... > Since we made that change, we have had a problem with some medium to > heavy-duty sql statements that appear to be using practically all of the > one CPU that Informix is using. Thus, all other Informix processes > (including our On-Line systems) are getting very little CPU and > performance goes down the toilet. > > Could the change in the MULTIPROCESSOR flag have caused the performance > problem or is this just my imagination? I have no experience myself yet on this, but yes. From everything said previously on this you shouldn't ever turn on the MULTIPROCESSOR flag until you have at least 4 processors. It's said to be something with the engine useing so much time for the switching between processors you may not gain anything, even loose, performance when you turn this on. Try going back and see if the problem dissapear. Nils.Myklebust@ccmail.telemax.no NM-data, Aasesvei 71, 1300 Sandvika, Norway My opinions are those of my company