re: CFC Query Question

2010-08-03 Thread Jason Fisher 

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:335943
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: CFC Query Question

2010-08-03 Thread Robert Harrison 

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: AW Unplugged
http://www.austin-williams.com/unplugged



-Original Message-
From: Jason Fisher [mailto:ja...@wanax.com] 
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

RE: CFC Query Question

2010-08-03 Thread Jason Fisher 

Makes sense.  Clearly, if you were testing for ID = '#myVar#', then the 
number of variances would make caching irrelevant, but it sounds like this 
case might be a good candidate.




~|
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:335945
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm