[prev in list] [next in list] [prev in thread] [next in thread] 

List:       rt-users
Subject:    Re: [rt-users] RTx-Shredder speed (or lack of!)
From:       Howard Jones <howie () thingy ! com>
Date:       2008-11-27 15:51:04
Message-ID: 492EC1E8.5020501 () thingy ! com
[Download RAW message or body]

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: sales@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com
[prev in list] [next in list] [prev in thread] [next in thread]