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