Performance issue when loading GroupContactCache in larger databases
I am attaching a sample from our slow query logs that shows that group loading is a problem for some of our Smart groups. In particular the code that checks for removed contacts looks like it could benefit from performance improvement.
The potential solution is similar to the other ticket on group performance that I have opened: #930
I have a patch for a partial solution so far and it doesn't break any of the existing tests. However I could use some guidance on making sure the tests cover enough cases of saved searches.
To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information