I generally see a pretty significant gain on Oracle as well. Thanks,
Eric Cobb http://www.cfgears.com Help me make a difference this summer - http://bit.ly/i8dJvQ On 5/2/2011 3:27 PM, Mark A. Kruger wrote: > 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:344143 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
