[rt-users] RTx-shredder with a very large database

Todd Chapman todd at chaka.net
Tue Feb 28 23:55:09 EST 2006

On Wed, Mar 01, 2006 at 12:19:10PM +1030, Luke Vanderfluit wrote:
> Not sure whether web-interface invoked actions and RT API processed 
> requests will be equal in performance to straigh SQL from perl script.
> Would have to test both to give objective reply.
> I have tried both API and direct sql, both _are_ slow.
> BTW.
> The stuff that I put in my script comes from the WIKI.
> http://wiki.bestpractical.com/index.cgi?DatabaseAdmin
> Kind regards.
> Luke

I would guess that it's the database work that is taking
the most time. You are guessing that it is the script
overhead. It would be better to benchmark Shredder before
you do a bunch of potentially wasted work. Perhaps adding
an index or two would speed things up...


More information about the rt-users mailing list