Re: Performance Decreasing

: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. >This sounds like something we have been encountering recently. It >uncovered a bug in Online (7.11 UC1 on Solaris) due to contention. We >found out about the bug from Tech support last Friday, so I haven't had >time to track it down, or even see if the slowdown phenomenon is related. Have you tried setting OPTCOMPIND to 1? The default is 2 I believe. We saw some strange behavior when the default was used on our HP 7.12 system. Tech support responded that our problem was a known bug with OPTCOMPIND when set to 2. I'm not saying that your problem is a bug, but it might be worth checking into. Good Luck