Thanks Charlie. Actually I learned a lot about client variables and how you stress in one of your presentation<http://experts.na3.acrobat.com/p56344520/>that each page visit creates new records with clientmanagement enabled. That was awesome presentation <http://experts.na3.acrobat.com/p56344520/>.
I wanted to get feedback from people to learn from their experience as well. Thats why I posted here. No one replied except for you. :-) Thanks a lot for your reply. I really appreciate it. We are in second category, i.e. we use client.lastvisit in code, hence the clientmanagement is enabled. Thats why I wanted to look at a better way to manage the purge process rather than CF waking up every hour. Thanks for the links as well. I did come across them when I searched on google but like I said, I was very keen to hear from people's experience and how they have handled this. Nothing to take away from you posting those links. I appreciate it. Thanks, <Ajas Mohammed /> http://ajashadi.blogspot.com We cannot become what we need to be, remaining what we are. No matter what, find a way. Because thats what winners do. You can't improve what you don't measure. Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives. On Wed, May 12, 2010 at 10:02 PM, Charlie Arehart <[email protected]>wrote: > 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 FusionLink <http://www.fusionlink.com> > -------------------------------------------------------------
