Tim Cutts wrote: > On 27 Nov 2008, at 1:14 pm, Howard Jones wrote: > Yes, it does take a lot of time, because the sorts of queries it makes > are not "normal" for RT, so there are no indices. I believe in 3.8 > much of this has been addressed, but certainly in 3.4 I have had to > add a lot of extra indices to make Shredder go faster (and even after > all that it's still fairly slow, but at least now I can delete several > hundred tickets an hour, when necessary) Ah, thanks Tim!
I had a brief heart-in-mouth moment when the Attachments index took 20-some minutes to build, blocking inserts in the process, but now I can shred 10 tickets in about 3 minutes - about 20 times faster. I've also enabled the slow-query-log, so I can perhaps tune it a bit more. Cheers, Howie (my case is for 3.6.4, incidentally) _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
