[rt-users] RT Slow to display

[Fezile Dyele]

After upgrade from 3.6.5 to 3.8.1

RT Slow to display after I click on top-left link [Tickets]
I've also tried to do a fresh installation and loaded new schema.
I then loaded my data which I created by:
  'mysqldump -p rt3 --no-create-info --copmlete-insert > rt3.sql'

Mysql shows slow query:

# Time: 081005 23:01:40
# User at Host: rt_user[rt_user] @ localhost []
# Query_time: 7  Lock_time: 0  Rows_sent: 2288  Rows_examined: 197572
SELECT DISTINCT main.* FROM Users main CROSS JOIN ACL ACL_2 JOIN
Principals Principals_1  ON ( Principals_1.id = main.id ) JOIN
CachedGroupMembers CachedGroupMembers_3  ON (
CachedGroupMembers_3.MemberId = Principals_1.id )  WHERE
(Principals_1.Disabled = '0') AND (ACL_2.PrincipalId =
CachedGroupMembers_3.GroupId) AND (Principals_1.id != '1') AND
(ACL_2.PrincipalType = 'Group') AND (Principals_1.PrincipalType =
'User') AND (ACL_2.RightName = 'OwnTicket' OR ACL_2.RightName =
'SuperUser') AND ((ACL_2.ObjectType = 'RT::Queue') OR
(ACL_2.ObjectType = 'RT::System'))  ORDER BY main.Name ASC;

Pls Help,
Fezile