[rt-users] any page showing a user drop down in a ticket is loading slow

[Landon Stewart]

On 17 December 2013 11:53, Adam Hobaugh <adam at 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 :: lstewart at iweb.com
Lead Specialist, Abuse and Security Management
Spécialiste principal, gestion des abus et sécurité
http://iweb.com :: +1 (888) 909-4932
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20131217/5037a9b7/attachment.htm>