Smith, Matthew P -CONT(DYN) wrote: > Does cfqueryparam speed up QofQ as it does with a normal db query? I would > think not, but it would be cool if it did. Just curios if anyone knows...
Probably no significant difference. The difference it makes is that one implicit type casting is replaced by one explicit type casting for each variable. To be honest, I can't imagine that CF MX actually caches execution plans. While in a real database (at least the ones I know of) the difference is mainly in the generation of the execution plan, and not the parsing of the statement. But it should be easy to test :) Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
