Re: Dynamic SQL and speed

> > 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 the 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 if you've got 5.0-on of the engine. akent@cix.compulink.co.uk (Andy Kent) -------------------------------------