Mysterious !! - Stored Procs Slowing Down

Posted in 1998

David Lapsley — 13 Jan 98 11:05:55 GMT — source: Informix-list mailing list archive (1991-1998)

We have a number of stored procedures which normally take < 1 sec to run. After a few days of running correctly they begin to take > 10 mins to run. (NOT a gradual degradation, either 1sec OR 10mins, no in between) The only method of resolving the problen is to DROP and RE-CREATE the offending procedure. Running update statistics does not help. We are running SE 7.20.UC2 on SCO Openserver Release 5 (INTEL). Any ideas greatly appreciated, its becoming a major headache. Thanks in advance David Lapsley