So with regards to dmArchive? What about objects in here that are labeled as type dmArchive, would it be safe to assume that this can be joined by the ObjectID with the ArchiveID from what I see these 2 objects need deleting.
On 5/28/07, modius <[EMAIL PROTECTED]> wrote: > > > On May 28, 3:47 pm, Andrew Scott <[EMAIL PROTECTED]> wrote: > > Cheers for your help, but when I ran that it timed out. And now it just > > errors each and every time I try to run it. > > > > But when I look at the content archives they are still sitting there > which > > tells me that doesn't do what I want it to do. > > > > I could sit here and write a query to do the job myself, but I do not > know > > enough about the relationships in the tables to make the script or code > to > > do the job myself as yet. > > 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. > > > > > -- Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
