Re: Informix 5 Performance Issues

On 17 Apr 97 at 18:22, David Williams wrote: } In article <5j4i8s$c7p@cssun.mathcs.emory.edu>, Billy Wheeler } <billy@west.co.za> writes } >Remember - YMMV, etc: } > } >On 16 Apr 97 at 17:04, Phantom173 wrote: } > [SNIP] } >> significant given the facts stated above. He is arguing for an increase } >> in the number of processors (plus some dramatic redesign of the database } >> and the application). } > } >Honestly, I know it's a cop-out, but you really should try it to see } >whether it works. I agree with your consultant. I couldn't see how } >many processes you were running in total, but context switching can } >become a significant overhead. I'm also sure that Sequent supports } >processor affinity - this means that you could tie up a CPU just to } >run an Online 7 virtual process, with resultant performance benefits. } > } >A redesign of your application may be important for other reasons, } >but I would hesitate to use that as my first step to improve } >performance!! } > } In Informix Online Performance Tning course the first thing is to } check the application. 90% of the performance improvement comes from } tuning the application code/database indicies. I agree, I've often found that profiling a small section of the app can have major benefits. However, the words "dramatic redesign of the database and the application" were used, and I was more worried about the possible botch ups of a major redevelopment in a production environment. :-) I hope that clarifies my position... -- Ciao, Billy Nose to the ground and ear to the grindstone in: Johannesburg Why is it hard for women to find men who are sensitive, caring and good looking? Because those men already have boyfriends.