Re: [rt-users] speeding up rt-shredder

[G.Booth]

On Tue, 27 Jul 2010 19:04:35 +0200
 ronald higgins <ronald.higg...@gmail.com> wrote:

Thanks for the response Maxwell,




'2010-07-26 07:00:00';limit,2" --sqldump
/tmp/shredder-restore-tickets.sql

SQL dump file is '/tmp/shredder-restore-tickets.sql'

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 <=

Hi Ronald





regards
Garry

--

Dr Garry Booth
IT Services
Loughborough University

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.

shredder.rtf
Description: Binary data

Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com