Re: Informix 7.1 performance on AIX 3.2.5 machine.

In article <3mhd5f$l89@dodge.eng.sc.rolm.com>, shyam@minerva.robadome.com (Shyam Davuburu) wrote: > We have been running our application which is compiled under Informix 5.2 and > the performance seemed to be pretty good. When we moved our upgraded Informix > rto 7.1 engine the performance is really bad. We have processes that use to > take few minutes under Informix 5.0 are taking hours to complete. We have not > compiled our application under 7.1. My company is also running 7.1 under AIX 3.2.5. One specific area we found a problem with was the use of subqueries. Performance in applications using them became horrible after we installed Informix 7.1 and recompiled with the 7.1 tools. Informix's helpful advice was not to use subqueries. Although we have been told that applications should be recompiled with the 7.1 tools, we have found that recompiling the applications using the 5.02 tools causes the performance to return to previous level. My feeling is that there is a bug in the 7.1 tools. (I am speaking specifically of ESQL/C applications). S. Eric Asberry