[rt-users] Slow Tickets after upgrading 3.4.1 to 3.6.6

[Roy Depp]

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.