[rt-users] speeding up rt-shredder

[Maxwell Rathbone]

  Cool! Thanks for posting this. I'll run some benchmarks against what 
I'm using now to see if this is any faster.

Max

On 7/27/2010 1:51 PM, G.Booth wrote:
> On Tue, 27 Jul 2010 19:04:35 +0200
>    ronald higgins<ronald.higgins at gmail.com>  wrote:
>> Thanks for the response Maxwell,
>>
>> So i've added in a date, but alas, still around the 40
>> second mark.
>>
>> rt-shredder --force --plugin "Tickets=query,Subject like
>> '%VIAGRA%'
>> and LastUpdated>= '2010-07-01 07:00:00' AND LastUpdated
>> <=
>> '2010-07-26 07:00:00';limit,2" --sqldump
>> /tmp/shredder-restore-tickets.sql
>>
>> SQL dump file is '/tmp/shredder-restore-tickets.sql'
> Hi Ronald
>
> We do all of our ticket shredding from one queue with the attached script.
> It might be worth running a few tests with it, to see if its the shredder
> query causing some overheads. You'll need to change the queue name from
> SPAM-Shredder to whatever you use for testing and stop it checking for
> whether the ticket is older than 7 days. Runs from /opt/rt3/local/bin
>
> Hope its of some help. Am away from the list for 2 weeks from tomorrow, so
> good luck.
>
> regards
> Garry
>
> --
>
> Dr Garry Booth
> IT Services
> Loughborough University