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

[Paul England]

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