It'd definitely be nice to get everything database-driven. That would save me some headaches.
But keeping with the same train of thought here. I reduced the caching timeout from 30 minutes down to 1 minute -- I hoped to see my memory start clearing up fairly quickly: <cfquery name="#queryName#" dbtype="query" cachedwithin="#createTimeSpan(0,0,1,0)#"> SQL </cfquery> Most users on the site don't stick around for longer than 1 minute, so I'm not worried about users having to do another lookup. And while it definitely seems to slow down the memory consumption rate, it still doesn't appear to be freeing up any RAM. I did some test runs, loading some of the larger files. I saw the corresponding RAM increase, but never seeing that memory released. I plan on converting it all to being database-driven, but I'm still confused as to why this memory isn't being released. Are the Queries being eliminated, but not removed from memory just yet? Is there a way to force garbage collection while CF is running so that I could test this theory? Jonathon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295054 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
