I've got an article almost done for the next issue of Fusion Authority on one of the techniques I use. Basically, cached queries are nice when you want to persist query data across time. On the other hand, they suck when you want to persist stored procedure data or queries that use the CFQUERYPARAM (as all queries should). They also have a problem when you want to update the data in one of the cached queries without destroying all of them or editing the physical code. The article details how to write a persisted CFC and use that persisted CFC to store a query for use. It goes into the issues of getting the query, storing it and resetting it. This technique can then be applied to any tag or function that returns any type of data. This is just one of the techniques I use and now that I have a second to write it up, you can all use it. :)
> Mike, > > When are you going to give a talk on all your performance tweaks > you've done to the HOF site? I think that many of us would find it > useful. > > larry > > On 7/22/05, Michael Dinowitz <[EMAIL PROTECTED]> wrote: > > I made some quick changes this morning to the HoF code to include > some more caching and the virtual memory used by CF is actually going > down! I love when tight code results in better resource managment. :) > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:5:166018 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
