[rt-users] Rtx::Shredder: Indexes for Performance improvements on deleting Tickets

[Mathew]

>From three hours to one minute?  I'll definitely have to test that out
because, quite frankly, I'm skeptical.  I only hope it's true :)

How many tickets do you typically shred per run?

Mathew

Dirk Pape wrote:
> Hello,
> 
> using Shredder Version 0.6 with
> 
> rtx-shredder --plugin
> "Tickets=limit,50;status,deleted;updated_before,`date -I -d '1 month
> ago'`" --force
> 
> I added the following indexes, that improved purging deleted Tickets
> from 3 hours to one minute.
> 
> on Transactions:
> 
>  KEY `Shredder` (`ReferenceType`,`OldReference`,`NewReference`),
>  KEY `Shredder2` (`Type`,`OldValue`,`NewValue`),
>  KEY `Transaction Order Created` (`Created`)
> 
> on CachedGroupMembers:
> 
>  KEY `Shredder` (`Via`)
> 
> may help some others if this is not already folklore.
> 
> Regards,
> Dirk.