Yes, 90 days is the default, and it is absolutely excessive! How long do you really need that data to stick around? 30 days? I doubt it. I bet 7 days is plenty long enough, 1 or 2 days is enough for any normal application. Often, the database cleanup doesn't actually happen, so you have to do it yourself. Also, transitioning away from client variables and into a more specific database structure (as opposed to the vertical storage [1 row per data element] that is used by client vars) would help you out a lot.
nathan strutz [www.dopefly.com] [hi.im/nathanstrutz] [about.me/nathanstrutz] On Thu, Nov 15, 2012 at 10:42 AM, Ian Chapman <[email protected] > wrote: > > 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:353193 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
