Our production RT instance (3.6.3 - old, I know) takes a really, really long time to add and remove group members.
Our database is MySQL and the CachedGroupMembers table has the index: KEY `CachedGroupMembers3` (`MemberId`,`ImmediateParentId`) What can we do to improve the situation (yes, I would be upgrading if that were possible at the moment)? Would running shrink_cgm_table.pl be a good idea? Thanks! -Todd