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

[Ruslan Zakirov]

Dirk, have you read changelog?

http://search.cpan.org/~ruz/RTx-Shredder-0.06/lib/RTx/Shredder.pm#Database_indexes

On 4/11/07, Dirk Pape <pape-rt at inf.fu-berlin.de> 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.
> --
> 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: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>


-- 
Best regards, Ruslan.