James Smith wrote: > the query is actually very complex involving several loops and a few > conditional clauses
Your query has several loops? You mean you actually use the new hierargical query features of MS SQL 2005? Or does the CF code that generates the query involve several loops and conditions? > and I am hoping that by sticking it all into a > stored procedure it will be precompiled by MSSQL and therefore more > efficient. So what part of the current execution time is spent in the compilation step? Because that is the maximum you will gain from it being precompiled. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280833 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4