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.
--
Dr. Dirk Pape (eAS - Projektleitung Campus Management)
Freie Universitaet Berlin
Grunewaldstr. 34a, 12165 Berlin
Tel. +49 (0)30 838 75143, Fax. +49 (0)30 838 54654
_______________________________________________
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
