Hi, After upgrading RT 3.41. to 3.6.6 tickets open slowly. Also when clickig the 1st time on "People" or "Basics" it takes about 8-12 secs to open up.
I've followed the wiki performance tuning page, and looked at the mailing list archive and followed this thread: http://www.gossamer-threads.com/lists/engine?do=post_view_flat;post=72605;page=1;sb=post_latest_reply;so=ASC;mh=25;list=rt Neither improved the situation. The slow query log shows nothing except the startup line. I've installed mytop and it seems like the long queries are of the following type: ========================================================= SELECT DISTINCT main.* FROM Users main CROSS JOIN ACL ACL_4 JOIN Principals Principals_1 ON ( Principals_1.id = main.id ) JOIN CachedGroupMembers CachedGroupMembers_2 ON ( CachedGroupMembers_2.MemberId = Principals_1.id ) JOIN Groups Groups_3 ON ( Groups_3.id = CachedGroupMembers_2.GroupId ) WHERE (Principals_1.Disabled = '0') AND (ACL_4.PrincipalType = Groups_3.Type) AND (Principals_1.id != '1') AND (Principals_1.PrincipalType = 'User') AND (ACL_4.RightName = 'OwnTicket') AND (Groups_3.Domain = 'RT::System-Role') AND ((ACL_4.ObjectType = 'RT::Ticket' AND ACL_4.ObjectId = 537) OR (ACL_4.ObjectType = 'RT::Queue' AND ACL_4.ObjectId = 4) OR (ACL_4.ObjectType = 'RT::System')) ORDER BY main.Name ASC ========================================================= Please help. Thanks, Roy. _______________________________________________ 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