Oninit cdi / Archive
Talk to an expert →

stored procs and recompiling

Posted in 2000

Topics: Stored Procedures & SPL, Server Administration, Versions, Editions & End-of-Life

Mike Talbot — — source: Informix-list mailing list archive (1991-1998)

IDS 7.3x on HPUX 10.2 Should stored procedures be recompiled on a periodic basis? We have a case where a procedure was taking 10 minutes , we then created the same procedure w/ a new name and it took 5 seconds. The tables involved do have records inserted/updated at a high frequency and are reindexed by our DBAs once a month. I am wondering if we should drop all procs and recreate them after this reindexing process. TIA for any help

↪ replying to Mike Talbot
Paul Tilles — — source: Informix-list mailing list archive (1991-1998)

Are your stored procedures being re-optimized through update statistics? Paul Tilles Mike Talbot wrote: > IDS 7.3x on HPUX 10.2 > > Should stored procedures be recompiled on a periodic basis? > > We have a case where a procedure was taking 10 minutes , we then created the > same procedure w/ a new name and it took 5 seconds. > > The tables involved do have records inserted/updated at a high frequency and > are reindexed by our DBAs once a month. I am wondering if we should drop all > procs and recreate them after this reindexing process. > > TIA for any help

↪ replying to Mike Talbot
Leonids.Voroncovs@dati.lv — — source: Informix-list mailing list archive (1991-1998)

Mike Talbot wrote: > The tables involved > are reindexed After this action You should 'update statistics for procedure <proc_name>'.

Glossary