[rt-users] speeding up rt-shredder

[ronald higgins]

Thanks for the link, it's helped, but hoping for more gains.

I've applied the indexes as described and edited the Record.pm and
it's knocked the deletes
down to 40 seconds per ticket. Which translates to about 115 200
records per day or a week solid
to delete my required 700 000 tickets.

Any other other ideas ?

Ronald

On Tue, Jul 27, 2010 at 3:30 PM, G.Booth <G.Booth at lboro.ac.uk> wrote:
> Hi Ronald
>
> You need to add some more indexes to a few of the tables.
>
> this thread explains all. Think we got to a point where we could shred one
> user/ticket every 3-6 secs or so
>
> http://lists.fsck.com/pipermail/rt-users/2009-November/062395.html
>
> hope it helps
>
> regards
> Garry
>
> --
>
> Dr Garry Booth
> IT Services
> Loughborough University
>