[rt-users] RT 3.6.4 poor query performance

[Jesse Vincent]

On Mar 13, 2008, at 8:46 AM, Richard Ellis wrote:

> Hi All,
>
> We have recently updated our RT instance from 3.4.6 running on  
> Solaris 9
> to a new server running Solaris 10 and 3.6.4.
>

You probably want RT 3.6.6 if you're on MySQL. Ruz did some serious  
query optimization.  But my first guess is that you've granted  
"Everybody" the right to OwnTickets somewhere.



> Everything works perfectly and we have removed all of the  
> customisations
> that we used to use for a virtually vanilla 3.6.4 install. However,  
> when
> opening the Query Builder page, performance slows to a massive extent.
> Average page load is under 1 second, but performing any action in  
> Query
> Builder averages 400 seconds.
>
> I thought it was the database so upgraded mysql from 5.0.34 to  
> 5.0.51a,
> but that made no difference. I then upgraded DBIx::SearchBuilder to  
> the
> latest version and DBD::mysql but it is still as bad. Even upgraded
> every single perl module to latest and restarted everything, but still
> as bad.
>
> mysqlcheck rt3 says everything is ok.
>
> There are only 10,000 tickets so it shouldn't be a volume problem.
>
> Running on perl 5.8.8.
>
> Anyone any ideas?
>
> Richard
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>

-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 186 bytes
Desc: This is a digitally signed message part
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20080313/85609c29/attachment.sig>