Stored Procedures

Posted in 1995

Dave Cook — Sun, 24 Sep 95 10:36:16 GMT — source: Informix-list mailing list archive (1991-1998)

Do you have any hints/tips/advice on Stored Procedures called from Informix 4gl? I have worked out how to prepare and execute them but I am now trying to assess what impact they will have on my application. How does the performance of SP's compare to using Views? What are the known problems? Is there a limit to the number of SP's I can hold in the database? If I have a large number of SP's what sort of impact will this have? Initially I will be using version 5.x of the Standard Engine but I will also be using them under On-line in the near future. Thanks. -- Dave Cook