[rt-users] speeding up rt-shredder

[G.Booth]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: shredder.rtf
Type: application/octet-stream
Size: 1583 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20100727/0f6cfbed/attachment.obj>