We're using a CFCLIENTS database as we run a load balanced cluster. Purge is set to 90 days which I *presume* was the default. Does maybe seem excessive?
-----Original Message----- From: Russ Michaels [mailto:[email protected]] Sent: 15 November 2012 17:36 To: cf-talk Subject: Re: Huge rowcounts in CFCLIENTS database how often do you have it set to purge ? We use cookie a sthe default storage method for client variables for years, never had any issues with it so far. On Thu, Nov 15, 2012 at 5:33 PM, Ian Chapman <[email protected]>wrote: > > Hi Guys, > > I just decided to take a look at our CFCLIENTS database and was > alarmed at the rowcounts: > > CDATA > > 30825485 rows > > CGLOBAL > > 34472178 rows > > Does this seem ridiculously high? > > We do have to restart CF from time to time due to issues with lots of > file manipulations/image creation etc. So would this mean that the > session data becomes orphaned from real sessions? > > And if the counts seem high what is the safe way to purge these tables? > > Regards, > > Ian. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353192 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
