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
