Same here. I'm not aware of a way (in CF) to achieve caching of execution plans without fully qualified, paramterized SQL. CFQUERYPARAM gets you the latter when done right.
.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -----Original Message----- From: Mark A. Kruger [mailto:mkru...@cfwebtools.com] Sent: Monday, May 02, 2011 4:28 PM To: cf-talk Subject: RE: Bless <cfqueryparam - helped defend against a persistent hack attempt I almost always see a significant gain in query performance - at least on all versions of MSSQL - as much as 20-30 percent in some cases. Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -----Original Message----- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Monday, May 02, 2011 1:54 PM To: cf-talk Subject: Re: Bless <cfqueryparam - helped defend against a persistent hack attempt > > 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. In your practice, perhaps. In the practice of others, not so much. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:344206 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm