On 17 December 2013 11:53, Adam Hobaugh <a...@cs.pitt.edu> wrote: > Hello, > > I just updated from 4.0.10 to 4.2.1 and it seems to be working well except > when I am in a ticket, any page that shows a user drop down, ie display and > people load incredible slowly. I enabled slow query logging and below are > the two queries that appear to be causing the problem. I appreciate any > help in resolving this. 10 second load times is rough. Please let me know > what further information is needed. >
Hi Adam, I’m not sure if this applies but we had this issue and it was an RT ACL issue. I remember that it was an issue with granting or not-granting rights to special groups "Everyone" or “Unprivileged” but the details of which I cannot recall exactly. I do remember there were large ACL joins in the database whenever we would try to load pages with these drop downs just like you’ve described in your post. -- Landon Stewart :: lstew...@iweb.com Lead Specialist, Abuse and Security Management Spécialiste principal, gestion des abus et sécurité http://iweb.com :: +1 (888) 909-4932