[rt-users] Large dataset in Owners Dropdown (Query Builder)

[Byron Jones]

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: rt-users-bounces at lists.bestpractical.com 
> [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf 
> Of Theo Kramer
> Sent: Tuesday, 8 August 2006 4:37 PM
> To: rt-users at lists.bestpractical.com
> 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: sales at bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
>