[rt-users] RT 3.6.1 - Query Builder is slow when loading initially

[Theo Kramer]

http://lists.bestpractical.com/pipermail/rt-users/2006-September/041771.html worked for me.

On Mon, 2007-01-08 at 16:22 +1300, Paul England wrote:
> Hi there,
>         
> We've been using the RT system for around two years now and it's
> absolutely fantastic.
> 
> Recently we upgraded from RT3.4 to RT3.6 and since that time we've
> noticed that when a user clicks on the Query Builder feature
> (Tickets/New Search) the initial load takes longer than 60 seconds.
> 
> Our Database uses MySQL 5 and our servers are all running Debian Sarge.
> 
> I've read quite a few archived discussions from other people
> experiencing similar issues, it appears that the problem may lie with
> the Owners drop down box and the query associated with it.
> 
> I have tried the following as the archived mailing lists have suggested:
> 
>  - Removed OwnTicket Right from Everyone group and only assigned it to
> techs/IT workers
> 
>  - Increased the MySQL maximum temporary table size, read buffer and
> sort buffer sizes
> 
> Unfortunately we still have the same problem, another thing we recently
> noticed is that our Users table has > 6000 records and our groups table
> has > 110000 records which seems rather odd.  (We use rt-mailgate which
> might explain the excess of user records)
> 
> Any suggestions or theories regarding the issue would be greatly
> appreciated as we're very stuck with this problem =)
> 
> Thank you,
> 
> Paul England
> Auckland, New Zealand
> _______________________________________________
> 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
-- 
Regards
Theo