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

Manage Groups time outs due to CRM-16483

          Details

          • Type: Bug
          • Status: Done/Fixed
          • Priority: Major
          • Resolution: Fixed/Completed
          • Affects Version/s: 4.6.8
          • Fix Version/s: 4.7.10
          • Component/s: None
          • Documentation Required?:
            None
          • Sprint:
            4.7.10 Performance
          • Funding Source:
            Contributed Code

            Description

            The addition of an OR join in this line

            https://github.com/civicrm/civicrm-core/pull/6141/files#diff-e54381bfdf51e31cab376c71ca0d66ffR2558

            takes the query duration from effectively instant to over 1 minute for a group with 0 contacts in it. (queries are killed on the server after 1 minute) on a DB with 100k+ contacts & several hundred groups.

            This query runs 25 times on the manage groups page so without the script killer would take min 25 minutes to load....

              Attachments

                Activity

                  People

                  • Assignee:
                    b.systopia Björn Endres
                    Reporter:
                    eileen Eileen McNaughton
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    9 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: