sql? truncate? On Tue, May 11, 2010 at 11:55 AM, Ajas Mohammed <[email protected]> wrote:
> 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 > > -- Steve Ross web application & interface developer http://blog.stevensross.com [mobile] (912) 344-8113 [ AIM / Yahoo! : zeriumsteven ] [googleTalk : nowhiding ]
