Geoff, I am still seeking a definitive answer to my question.
Can the dmArchive type in the objects table that has the same archiveId in the dmArchive table be deleted as well. I am assuming yes but would like to know 100% before I do this on a production server database. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of modius Sent: Monday, 28 May 2007 7:20 PM To: farcry-dev Subject: [farcry-dev] Re: Audits and Archives To remove data from the audit table.. feel free to truncate the table completely. There are no relationships -- its a log only. With respect to archives, you can delete records from the dmArchive table using datetimecreated as the property to limit your deletes. The only purge option available is for stats -- if that times out then you have too many stats. My overall recommendation to folks who can't periodically prune the stats table, is to turn off stats completely and use your web logs or Google Analytics. Regards, -- geoff http://www.daemon.com.au/ PS. These community forums are not an appropriate place for emergency support -- the "developers" only peruse the forums when they have free time and generally in their own time. You might consider a commercial support contract to address priority issues. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "farcry-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/farcry-dev?hl=en -~----------~----~----~----~------~----~------~--~---
