Re: What's the problem with stored procedures

Kirk Waterhouse wrote: > > I had an Informix employee (a fairly high level consultant type) tell me > that I should not use stored procedures with Informix. He said that > Informix did a very poor job of implementing stored procedures. He said > that they were parsed at run-time, showed poor performance and in > general caused problems within the engine. He said triggers were at > least as bad. > I was wondering if the user community has experienced problems with SPL > and triggers in Informix. > > I am using 7.23.UC1 on AIX 4.1.5 for both OLTP and Data warehouse > applications if this has any bearing. This was true in early 5.0x releases, it is not a problem in 5.05+ or 7.xx. Actually it was compiled then translated into byte codes to hex digits and stored. The new versions are much better, plus ODS 7.xx added a stored procedure cache which eliminates the problem althogether for active procs, the cache can be seeded by updating stats on crucial procedures when the engine comes online. Art S. Kagel