i found the earlier versions of RT ignored disabled queues when building their list of owners, while new versions do not.
try restricting access for everyone to your disabled queues. > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of Theo Kramer > Sent: Tuesday, 8 August 2006 4:37 PM > To: [email protected] > Subject: [rt-users] Large dataset in Owners Dropdown (Query Builder) > > Hi > > We are in the process of upgrading our RT from 3.0 to a later version. > So far I have tried 3.4.4, but unfortunately have a problem > with response on opening the Query Builder. Trawling the > mailing list archives I came across a thread starting at > > http://lists.bestpractical.com/pipermail/rt-users/2005-Decembe > r/036258.html > > which discussed the problem. On the basis of the above I > decided to upgrade to 3.4.5 but still have the same problem. > > On digging deeper I discovered that the difference between 3.4.4 and > 3.4.5 caused the query (MySQL) to perform somewhat better, > however, the problem is not the actual query but rather in > the size of the data set returned. > > In 3.0 opening Query Builder only requests privileged users, whereas > 3.4.4 and 3.4.5 return around 97000 odd users in our case. > This causes both Apache on the server and the web browser on > the client to choke. > > The GET request from the Apache(2) log is as follows > > GET /rt3/Search/Build.html HTTP/1.1" 200 7931698 > > clearly illustrating the extent of the problem. > > > Any comments, suggestions on how I can overcome this problem > will be much appreciated. > > -- > 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 > _______________________________________________ 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
