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. _______________________________________________ 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