Re: Performance decreasing

Posted in 1996

Nils Myklebust — Tue, 27 Aug 1996 14:55:32 GMT — source: Informix-list mailing list archive (1991-1998)

dehkmis@hk.super.net (Durable MIS) wrote: :Our system has encountered a problem. At the beginning, the system retrieves :the data from the database very fast using index search. However, the :performance is greatly declined as our system running a long period (4 :hours, only one program). :When set explain on, we discover the informix using index searching. We wonder :why the performance is dropped ? Could anyone encounter this problem ? :Our informix server is Online 7.11 UC1 in HP-UX 10.01. When did you do update statistics last? If you don't do that you will usually se the results you see. The engine no longer selects the right indexes and join paths. If you haven't allready RTFM heavily on update statistics. Otherwise there may be a number of problems related to tuning of the engine as well as your OS. Nils.Myklebust@ccmail.telemax.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company