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 # [EMAIL PROTECTED]: 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 _______________________________________________ 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
