Thanks Dave, I searched my site and I was only using client variables a few time and it was all in the application.cfm page. I just switched them to session variables instead of client and I disabled clientManagement. This fixed the issue.
Thanks, Paul -----Original Message----- From: Dave Watts [mailto:[email protected]] Sent: Wednesday, February 24, 2010 12:58 PM To: cf-talk Subject: Re: CDATA / CGLOBAL Purging > I recently installed Fusion Reactor on my server. While viewing queries that > every page hit I noticed a query that I didn't recognize that was taking up > a significant amount of load time. These queries were to the tables CDATA > and CGLOBAL. > > Upon research I found that this was caused by our server storing client > variables however looking at the table, there was about 6 million records > going back more than a year. I looked in the ColdFusion Admin under Client > Variables and it says it's supposed to purge unwanted visitors every 90 > days. I changes that to 2 just to test (this was actually done on our > testing server). > > Anyway, I haven't seen any change in records. Does anyone have any ideas on > how to decrease the overall amount of records stored? First, are you actually using client variables in your application? If not, just disable this option and be done with it. Second, are you using the specific variables Client.HitCount and Client.LastVisit? If not, go to your client variable repository settings in CF Administrator and check "disable global client variable updates" or whatever it's called. Third, set up a scheduled task in your database server to periodically delete these records. If you don't actually use them for long-term persistent storage, run the scheduled task daily. Fourth, I really hope you're not using MS Access for this, as you will encounter very poor performance even after deleting records - you also have to shrink the database periodically. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331098 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
