[rt-users] Is this slow? It seems slow.

[Jamie Wilkinson]

This one time, at band camp, Val Luck wrote:
>You mentioned that upgrading to RT version 3.0.3 (which is out now) could fix it?  Updating DBIx::SearchBuilder looks like a perl mod upgrade from CPAN, not RT?  Regardless, I'll look into it.
>
>I can't believe that you have some db queries that are taking 20 minutes ..?!?  Wow.  Are you sure that's minutes and not seconds?  That would render RT useless.  :-(  I sure hope I don't see any degradation of that magnitude when I upgrade.
>
>If you do add any more indexes for performance, it would be great if you could email me or the rt-users list.  I'll do the same.

You're replying to an old email, since then we've upgraded RT to 3.0.3 and
DBIx::SearchBuilder to 0.86 (I think that's the latest version), and the
WhoHaveRight query is much much faster.

But see the thread on rt-devel regarding Sybase and mysql, for a patch that
seems to improve performanve even more for everyone.

-- 
jaq at spacepants.org                           http://spacepants.org/jaq.gpg