[rt-users] speeding up rt-shredder

[Maxwell Rathbone]

  What command are you running to run shredder?

For me, the best way to speed it up, was to ensure that I was specifying 
a date range, and to break it down into chunks(like one command per month)

Max

On 7/27/2010 10:45 AM, ronald higgins wrote:
> 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
>>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com