That's exactly why I set it to only purge going back 1m records. It's not ideal (I'd like to have that audit log), but it's a necessary tradeoff.
-- Jeff Coughlin On Jan 11, 2012, at 10:09 AM, Colin Jones wrote: > One thing we have noticed is that it does remove the "audit log" data > on objects (accessible in the webtop from the miscellaneous tab on the > overview page of an item), so if you want some audit data on who did > what to a content item you may want to make sure you set the deletion > period appropriately. > > On Jan 9, 10:16 pm, Blair McKenzie <[email protected]> wrote: >> Jeff is right about farLog - it's only functional use is to make sure bots >> can't brute force the webtop login, which means that it is safe to prune as >> much as is appropriate for your application. >> >> Leaving refObjects records there won't break FarCry, but they can have a >> performance impact, so it's a good idea to clean refObjects after manually >> deleting records. Here's a quick-and-easy query: >> delete from refObjects where typename='farLog' and objectid not in (select >> objectid from farLog); >> >> Blair >> >> >> >> >> >> >> >> On Tue, Jan 10, 2012 at 2:18 AM, Colin Jones <[email protected]> wrote: >>> Our farLog table is now exceeding 2.5 million rows, which is starting >>> to have a noticeable effect on access in the webtop with some queries >>> taking 2-3 seconds to run. A few questions... >> >>> Is it safe to "prune" farLog? >>> Can we just pick an arbitrary date and delete records from it before >>> that date? >>> Do we also need to delete associated refObjects entries for the farLog >>> data? >>> What are the conseuqences of doing this (simply removal of audit >>> data?) >> >>> Cheers, >>> Colin. >> >>> -- >>> You received this message cos you are subscribed to "farcry-dev" Google >>> group. >>> To post, email: [email protected] >>> To unsubscribe, email: [email protected] >>> For more options:http://groups.google.com/group/farcry-dev >>> -------------------------------- >>> Follow us on Twitter:http://twitter.com/farcry > > -- > You received this message cos you are subscribed to "farcry-dev" Google group. > To post, email: [email protected] > To unsubscribe, email: [email protected] > For more options: http://groups.google.com/group/farcry-dev > -------------------------------- > Follow us on Twitter: http://twitter.com/farcry -- You received this message cos you are subscribed to "farcry-dev" Google group. To post, email: [email protected] To unsubscribe, email: [email protected] For more options: http://groups.google.com/group/farcry-dev -------------------------------- Follow us on Twitter: http://twitter.com/farcry
