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

[Todd Chapman]

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

-Todd