Re: Informix 7.1 performance on AIX 3.2.5 machine.
Try running sql statement "update statistics".
This should be run on high transaction tables daily via cron and a shell
script which can be called via dbaccess command.
The statistics should be run when tables are reloaded.
Regards,
Nigel Trickett
vanadas@iconz.co.nz
In article <3mjb85$epc@cssun.mathcs.emory.edu>,
cwakins@leia.alloys.rmc.com says...
>
>} 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 |
> |________________________________________________________________|