> 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:331089 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
