[rt-users] Intermittent slow logins on RT 3.6.3

[Emmanuel Lacour]

On Mon, Jun 30, 2008 at 05:53:03PM -0400, Allen Chen wrote:
> Hi everyone,
>

Hi,

>
> It seems like RT is doing something after authentication and before  
> building the home page that makes logins slow.  I have a feeling it  

RT builds a cache of all allowed queues (that makes a bunch of acl
queries) that will be displayed everywhere in RT (QuickCreate,
QuickSearch, ...). This cache is kept in sessions.  So if you log in
again with the same browser and computer, it doesn't need to rebuild the
cache and it's "fast". That's why we have this typical difference
between first and second login.


> might be database related, but I cannot find any evidence of any slow  
> queries in rt.log.  Could there be any queries that RT executes that  

You would better look in the DB log and activate slow queries login.

Also keep in mind that RT does a lot of small queries, so 0.5s can be
really slow for an RT ACL query because you will have hundred of this if
you have several queues.

> Are there any bugs in 3.6.3 that would cause this?  Can anyone suggest  
> anything else I should look at or try?
>

If you're problem is related to a high number of queues, you can enhance
a bit by upgrading RT or at least grabing the
share/html/Elements/Quicksearch from 3.6.5 which have a performance
optimisation.
You can also remove the Quickcreate at the bottom of RT at a glance if
you don't need it (Createticket in the header is often enough) and save
more queries.