>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. _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
