Only suggestion I have is don't overlook DB level caching if it is available in your environments. We're using MySQL and have seen excellent performance from its built-in query caching. And the great plus is that the dB level caching it smart enough to know when tables have been updated and therefore automatically clear the appropriate caches as needed. So you can be less concerned about what events should clear the cache or how long to keep it. You can off-load that logic to the db.
May not be an option for you, but I wanted to mention it in case. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Arehart Sent: Thursday, February 15, 2007 1:44 PM To: [email protected] Subject: RE: [CFCDEV] where to do query caching... Hugo may have shot himself in the foot mentioning BlueDragon there, as those who don't use it might have turned off immediately thinking they couldn't help. Note that (it seems to me) his question isn't about BD but rather more generically about where best to implement query caching in CFML when using frameworks. Just forget that he mentioned BD. :-) It simply adds some additional attributes to the existing CACHEDWITHIN and CACHEDAFTER of CFQUERY. I sense his question is whether to bother using those at all (even in CFMX) or to use something else, like caching the results in memory using other techniques, and doing it elsewhere in the chain of events that process a query within a framework. /Charlie http://www.carehart.org/blog/ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hugo Ahlenius Sent: Thursday, February 15, 2007 4:23 AM To: [email protected] Subject: [CFCDEV] where to do query caching... Hi, Any thoughts on where to implement query caching... ? I am using BlueDragon.Net, and it has some quite neat and fancy improved support for query caching, that I haven't implemented yet (I had actually forgotten about it, until it was brought up on the bluedragon-interest mailing list). Basically it lets you group and cache things in the cfquery cache, with some additional functionality compared to CFMX (at least compared to CFMX 6.1 - have no experience with CFMX7, yet) In working with Mach-II (my framework of choice), and I am kind of reluctant to implement too much of the caching directly into the model. Unless it is made as a part of the model with optional caching arguments to gateways and DAOs - getProducts(cache=true) or something. Currently I have my caching set up more closely to the application framework, and that works very well too (and is fully CFMX compatible), where some queries are cached in the listeners (the intermediate objects that acts as the interface between the framework and the model). Any comments? /Hugo -- Hugo Ahlenius ------------------------------------------------------------- Hugo Ahlenius E-Mail: [EMAIL PROTECTED] Project Officer Phone: +46 8 412 1427 UNEP GRID-Arendal Fax: +46 8 723 0348 Stockholm Office Mobile: +46 733 467111 WWW: http://www.grida.no Skype: callto:fraxxinus ------------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, please follow the instructions at http://www.cfczone.org/listserv.cfm CFCDev is supported by: Katapult Media, Inc. We are cool code geeks looking for fun projects to rock! www.katapultmedia.com An archive of the CFCDev list is available at www.mail-archive.com/[email protected] You are subscribed to cfcdev. To unsubscribe, please follow the instructions at http://www.cfczone.org/listserv.cfm CFCDev is supported by: Katapult Media, Inc. We are cool code geeks looking for fun projects to rock! www.katapultmedia.com An archive of the CFCDev list is available at www.mail-archive.com/[email protected] You are subscribed to cfcdev. To unsubscribe, please follow the instructions at http://www.cfczone.org/listserv.cfm CFCDev is supported by: Katapult Media, Inc. We are cool code geeks looking for fun projects to rock! www.katapultmedia.com An archive of the CFCDev list is available at www.mail-archive.com/[email protected]
