Ajas, make sure you're addressing the root cause for all those client variable records: have you considered turning on the "disable global variable updates" option for your client variable repositories (databases and/or registry)? The default behavior updates or creates new records on each page visit to templates with clientmanagement enabled. This is something I've discussed in more detail in blog entries and presentations at my site (carehart.org).
If you don't make sure that's set properly for your environment (disabled if you never use client.lastvisit or client.hitcount in code), then worrying about the frequency of the purge is a bit like "rearranging deck chair on the titanic". That said, if you DO need those enabled, then of course it does make sense to better manage the purge process. (Same with if you do disable the setting, but it takes time to purge the old records that remain from past visits.) As to the SQL to use, had you seen that offered by Adobe in this technote: http://kb2.adobe.com/cps/185/tn_18514.html. There's also more from Dan short at http://www.dansshorts.com/post/sql-blocking-and-client-variable-purge. HTH. /charlie From: [email protected] [mailto:[email protected]] On Behalf Of Ajas Mohammed Sent: Tuesday, May 11, 2010 11:55 AM To: [email protected] Subject: [ACFUG Discuss] strategies for client variables purge CF 7 Hi, We are on CF 7, SQL SERVER 2000. I wanted to get an idea of what others do in terms of CF client store setting which is by default to purge client variables after every 1 hour and 7 minutes. Is it a good idea to give a long number lets 8 hours 0 minutes, that way CF doesn't wake up very often to do purge and in the background during night hours, the client variables purge can be handled through a SQL Server job through a script. If you dont mind sharing your sql script for purge, please email me, as I would love to have a look at it. We have about 10-12 databases and I noticed the count in both CDATA, CGLOBAL in every database is about 200,000 to 300,000. Thanks, <Ajas Mohammed /> http://ajashadi.blogspot.com ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
