Yeah, I've had the same problem as well. We ended up creating a SQL Server job that nuked old records instead.
----- Original Message ----- From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, January 11, 2003 10:10 PM Subject: Re: CDATA Insert problem > I should have been more clear... > > They had configured the CFMX Administrator to delete inactive records after > 3 days. When we looked at the CDATA and CGLOBAL tables there were records > going back to June of 2001! > > The site is an extranet site, not a public web server... and no, they're not > THAT busy. ;-) > > Nothing was being deleted... and nothing ever had been deleted from those > tables. > > I've experienced this same thing on some of my own systems as well. > > -Novak > > ----- Original Message ----- > From: "Kwang Suh" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Saturday, January 11, 2003 9:00 PM > Subject: Re: CDATA Insert problem > > > > > You might want to check your CDATA and CGLOBAL tables and make sure you > > > don't have a ton of records in there. It has been my experience that > the > > > CDATA and CGLOBAL tables DO NOT get purged like they're supposed to. > For > > > example, if you tell the CF Administrator to clear records older than 3 > > days > > > it simply doesn't happen. I've experienced this problem in CF5 and > CFMX. > > > In fact, just the other day a client of mine (who had it set to clear > > > records older than 3 days) discovered over 2.8 million records in each > > > table! > > > > Perhaps his site is very busy? Also, CF only deletes inactive records > after > > X days. > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
