Re: RE: Stored Procedures

Mark.Denham@bbc.co.uk (Mark Denham) wrote: > >Dave Cook writes: > >>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. A piece of advice with stored procedures and INFORMIX - try to limit the body of the stored procedure as much as possible to SQL statements. If you place too much program logic in the stored procedure your performance will slide. The idea here is that the client machines take care of program logic (if..thens, etc..) while the stored procedures act as conduits for executing SQL statements. Hence, if you know the structure of your SQL ahead of time SPL makes sense. But if you are writing code that dynamically builds different SQL statements, then stored procedures are probably not the way to go.