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

Advanced Search on relationship to group members runs very long

    Details

    • Type: Bug
    • Status: Open
    • Priority: Trivial
    • Resolution: Unresolved
    • Affects Version/s: 4.6.33
    • Fix Version/s: None
    • Component/s: Core CiviCRM
    • Labels:
      None
    • Versioning Impact:
      Patch (backwards-compatible bug fixes)
    • Documentation Required?:
      None
    • Funding Source:
      Needs Funding
    • Verified?:
      No

      Description

      On an installation with more than 100K contacts, searching for contacts with a relationship to members of a group runs very long on the server (past a five minute front end timeout).

      This is the case even with a non-smart group of 37 contacts (and fewer than 1000 total relationships).

      The same search, done via reports instead, works fine.

      Does not reproduce on 4.7 demo, but then that only has a smaller number of contacts.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              larssg Lars Sander-Green
            • Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: