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: [EMAIL PROTECTED] > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com -- Regards Theo _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
