Jason, 1) We have around 17K of records in there, that are going back around 2 years.
2) It is possible that the stats need to be purged often, but I have already done that. And it is switched off. 3) I do not have access to the DB from an Admin point of view, only from a user point of view. And this needs to be an automated option that runs once a week, nightly and left at that. 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 Jason Sent: Thursday, 31 May 2007 4:23 PM To: farcry-dev Subject: [farcry-dev] Re: Still seeking an answer Geoff : RE: [farcry-dev] Re: Audits and Archives Hi Andrew, Out of curiosity how many records are in your dmArchive table? I think the largest dmArchive table I have seen from our biggest client has around 7000 records. I am not sure what sort of gain you would get by truncating a table of this size. Remember this table is only populated when you create draft objects and archive items etc. Are you sure you just don't need to purge the stats table which can definitely grow to a large amount if not regularly purged. If you have space limitations I would disable stats and rely on the weblogs for reporting purposes. Is this sql server? In which case a good starting point is to also check the databases transaction log and consider truncating and shrinking it. You should definitely do this if you have just purged an extremely large stats table. A guide for truncating and shrinking sql logs is available at: http://www.sql-server-performance.com/fg_sql_server_agent.asp FYI the fixrefobjects function Geoff mentioned removes orphan records from the refobjects table. Regards, Jason. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
