A few years ago we started adding a group as AdminCc to many tickets.
It made sense for our process and seemed like a good idea at the time.
Fast forward to today. This group is AdminCc on many, many tickets.
Now when we add a new member to the group it can take 15 minutes for
the add to complete, usually with the web interface timing out.
To alleviate this situation I wrote a script to remove this group from
many old tickets, but this too is taking a long time to complete.
Here’s the key line from the script:
my ($status, $msg) = $t->DeleteWatcher(PrincipalId => $pid, Type =>
“AdminCc”, Silent => 1);
Which causes this long running mysql query:
State: Sending data
Info: SELECT main.* FROM CachedGroupMembers main WHERE ((main.Via
= ‘28522070’)) AND ((main.id != ‘28522070’))
Can anyone recommend an approach to fixing this problem?