Re: Informix 7.1 performance on AIX 3.2.5 machine.

} From: shyam@minerva.robadome.com (Shyam Davuburu) } Subject: Informix 7.1 performance on AIX 3.2.5 machine. } } Hi, } } 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. } [...] } ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ } Shyam Davuluru Phone #'s: (408)249 3062 (R) } Email Address: shyam@minerva.robadome.com (408)492 7328 (W) } Siemens Rolm Communications } Have you re-built your indexes? According to the "Upgrading to Informix-Online Dynamic Server Training Manual", pg 16-389: "When the OnLine system has been converted to INFORMIX-ODS, all user tables created in version 5.x are marked as down. They are unusable until they are converted to the new index format that includes the delete flag." __________________________________________________________________ | Clem Akins Standard Disclaimers Apply | |Reynolds Metals Co, Alloys Plant "Climb High, Cave Deep!" | | Muscle Shoals, Alabama USA cwakins@leia.alloys.rmc.com | |________________________________________________________________|