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<[email protected]> 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
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
