[rt-users] RT 3.2.3 -> 3.4.4

[J.P. Racine]

The speed issues are related to SELECT DISTICT where using the query builder
causes a timeout ( past what fastcgi is set to 120-240 )

FastCGI 2.4.2
Apache 1.3.34
Mysql 4.1.15

3 Query       SELECT DISTINCT main.* FROM Users main , Principals Principals_1,
ACL ACL_2, Groups Groups_3, CachedGroupMembers CachedGroupMembers_4  WHERE
((ACL_2.RightName = 'OwnTicket')) AND ((CachedGroupMembers_4.MemberId =
Principals_1.id)) AND ((Groups_3.id = CachedGroupMembers_4.GroupId)) AND
((Principals_1.Disabled = '0')or(Principals_1.Disabled = '0')) AND
((Principals_1.id != '1')) AND ((main.id = Principals_1.id)) AND  ( (
ACL_2.PrincipalId = Groups_3.id AND ACL_2.PrincipalType = 'Group' 
                AND (   Groups_3.Domain = 'SystemInternal' OR Groups_3.Domain =
'UserDefined' OR Groups_3.Domain = 'ACLEquivalence')) 
                 OR ( ( (Groups_3.Domain = 'RT::Queue-Role' )  )  AND
Groups_3.Type = ACL_2.PrincipalType) )  AND (ACL_2.ObjectType = 'RT::System' OR
(ACL_2.ObjectType = 'RT::Queue') )    ORDER BY main.Name ASC
051021 18:31:59       

4 Query       SELECT  * FROM Users WHERE id = '1'

Should I be flushing tables of cached Principle/Group data? Would the procedure
be to list deleted then shred them?  If not how are the rest of you doing it?