Skip to content
GitLab
  • Menu
Projects Groups Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in
  • CiviCRM Core CiviCRM Core
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 1,465
    • Issues 1,465
    • List
    • Boards
    • Service Desk
    • Milestones
  • Deployments
    • Deployments
    • Releases
  • Wiki
    • Wiki
  • Activity
  • Graph
  • Create a new issue
  • Commits
  • Issue Boards
Collapse sidebar
  • Development
  • CiviCRM CoreCiviCRM Core
  • Issues
  • #1122
Closed
Open
Created Jul 16, 2019 by lolcode@lolcode

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.

performance-problem-samples.txt

Edited Jul 16, 2019 by lolcode
To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information
Assignee
Assign to
Time tracking