Ben, Just wanted to say that I read this article on your site, and wish to add one thing that I do that can help manage the cached queries.
I started to create some complex custom tags, and when I started to add the caching of queries I discovered I also needed a way to make the data appear to change. The solution was to allow the system that changed/inserted the query, to change a variable that the cfquery used to cache the query. For those queries that don't change much this does make a huge difference in speed, as indicated by Ben's article. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
