Re: Dynamic SQL and speed

I don't know how relevant this is - but aren't stored procedures optimised once and used many times unless Update Statistics are run for the procedures? > Article: 10816 of comp.databases.informix > Newsgroups: comp.databases.informix > Path: cix.compulink.co.uk!akent > From: akent@cix.compulink.co.uk ("Andy Kent") > Subject: Re: Dynamic SQL and speed > Message-ID: <Cxxs8L.66E@cix.compulink.co.uk> > Organization: Andy Kent Associates Limited > References: <37u5to$afp@www.interramp.com> > Date: Wed, 19 Oct 1994 20:14:45 GMT > X-News-Software: Ameol > > > > My systems admins at a development site just started using dynamic > SQL. > > This seems to have speeded the transactions (posting to the database) > > tremendously. The Audit files and transaction log sizes were also > reduced > > considerably. Does anyone have experience with this? Is there a > downside> to this apparent windfall? > > > Thanks, > > > Bill > > There is no downside if you use it properly - ie. structure your program > so that each query only gets parsed once. You are simply saving t > engine parsing each query every time it sees it. > > Another equally effective, and less messy code-wise, method, is to write > SQL-intensive routines in SPL (Stored Procedure Language), that is > you've got 5.0-on of the engine. > > > akent@cix.compulink.co.uk (Andy Kent) > -------------------------------------