Re: slow performance

Posted in 1998

alp koray tasdemir — Wed, 1 Apr 1998 14:02:01 +0300 — source: Informix-list mailing list archive (1991-1998)

> I am running ODS 7.23 u4 on HP 10.20 > So many users complained about slow performance...I looked at "top".... > IDLE has been around 21% > %WCPU 36% == (command) oninit > %CPU 35% == (command) oninit If this slow performance occurs when running a query it may be because of the optimizer hint parameter; you can check about the index usages with set explain on; and decide to use the optimizer or not. Also if there are many updates and inserts going on around your databases; it is recommended to run update statistics or update statistics high once a while. Alp Tasdemir