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 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. -- You received this message because you are subscribed to the "Houston ColdFusion Users' Group" discussion list. To unsubscribe, send email to [email protected] For more options, visit http://groups.google.com/group/houcfug?hl=en
