Re: Informix hogging CPU

In article <01bcc7c5$2c0d86e0$14203fce@mmatt>, mmatt@halcyon.com says... >10.10. When Informix gets hit with an SQL statement doing a few joins an a >35,000 record database, the system just crawls while the statement >executes (takes about 5 minutes). No one can login and if you are logged >in, you get a response to hitting ENTER about 40 seconds after hitting it. Informix 7.14 under single-processor HPUX systems had/has a major problem where no matter how you set the engine up, the oninit process priority would age and the database would get slower and slower and slower. Informix has been working on it; I've seen behavior such as you say, but when I saw it, I don't think it was related to a specific query; it seemed to be more related to how long the engine had been up and how much the databases had been used in that period. HP does has a patch that can put the engine into a separate process group and let you manually set the priority. You might want to contact them and Informix for the latest word. -- William Harris william@carsinfo.com Check out the NAGS spam filter. http://www.nags.org