It's testing as I expected. I'm trying to maximize the efficiency of my CFCs by writing more variable queries and caching those that have only a limited number of possible query parameters.
Thanks Robert B. Harrison Director of Interactive Services Austin & Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be &. Plug in to our blog: A&W Unplugged http://www.austin-williams.com/unplugged -----Original Message----- From: Jason Fisher [mailto:[email protected]] Sent: Tuesday, August 03, 2010 2:52 PM To: cf-talk Subject: re: CFC Query Question Well, that code will create a separate cache for each version of the variable query statement. Cf http://forums.devshed.com/coldfusion-development-84/cfml-cfquery-cachedwithi n-does-changing-order-by-create-new-query-680793.html In other words, I think it will work the way you expect. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335944 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
