Sure, your MS Access DB doesn't cache execution plans, but real databases do.
On Tuesday, 3 May 2011, <> wrote: > > >>cfqueryparam creates bound sql parameters, which improve query performance. > > This is purely theoretical, in practice, the gain in performance is > neglectible. > I prefer have a query to take 11 ms and see the values submitted in case of > error, than having the same query take 10 ms, but no information in errors. -- -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344150 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm