Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-13425

Group cache refresh performance

          Details

          • Type: Improvement
          • Status: Done/Fixed
          • Priority: Major
          • Resolution: Duplicate
          • Affects Version/s: 4.3.5
          • Fix Version/s: Unscheduled
          • Component/s: None
          • Labels:
            None

            Description

            Following on from CRM-12466 this bug reports the fact that the rebuild process for smart groups can exceed the allowed query time if there are a lot of smart groups / complex relationships in the group conditions.

            In short a better method of invalidating and rebuilding the smart groups on contact add/delete is required. (this is hard because a contact add/delete could affect group membership indirectly because of relationships and so is not as simple as simply removing all smart group cache entries refering to the contact modified)

              Attachments

                Issue Links

                is supplemented by

                Bug - A problem which impairs or prevents the functions of the product. CRM-14770 CiviGroup Roles Sync Slows User Login

                • Major - Major loss of function.
                • Won't Do

                Patch - A patch that fixes a known bug or implements a wanted feature CRM-18109 Remove unindexed use of function (group caches)

                • Trivial - Cosmetic problem like misspelt words or misaligned text.
                • Done/Fixed
                supplements

                Bug - A problem which impairs or prevents the functions of the product. CRM-17463 Deadlocks on group_cache clearing

                • Major - Major loss of function.
                • Done/Fixed

                  Activity

                    People

                    • Assignee:
                      Unassigned
                      Reporter:
                      jamessharpe James Sharpe
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      5 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved: