[rt-users] rt-shredder - quicker method?

[Ruslan Zakirov]

Hello,

In additon to indexes described in shredder documentation people
suggested index on Via column in CachedGroupMembers table and said
that it improves performance amazingly.

On Wed, Jun 24, 2009 at 8:32 PM, Timothy
Arnold<timothy.arnold at uksolutions.co.uk> wrote:
> Hi All,
>
> I've got an RT system (3.8) with a database 50G, and around 500k of tickets. I'm using rt-shredder to delete tickets older than 2 years, and it's taken about 2 days to delete around 20k. I estimate it will take around 30 days to complete.
>
> Is there any way to speed up the process? I toyed with the idea of deleting the tickets manually and using rt-validator to correct the database but I feel this might be a step too far...?
>
> Thanks
> Tim
>
>
> Timothy Arnold
> Senior Engineer, Operations (Network, Security & Facilities Group), UKSolutions

-- 
Best regards, Ruslan.