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

Dedupe should create indices for rules referring non-indexed columns

    Details

    • Type: Improvement
    • Status: Done/Fixed
    • Priority: Major
    • Resolution: Fixed/Completed
    • Affects Version/s: 2.1
    • Fix Version/s: 2.2.0
    • Component/s: Core CiviCRM
    • Labels:
      None

      Description

      The dedupe rules shipped by default are referring columns that have indices, but if somebody creates a rule group with a rule referring a non-indexed column, the rule can be rather slow with larger databases (and can impact the users very much if that rule is used in profile creation, for example).

      Upon rule group creation/alter, dedupe should check whether all of the referred column (or column pairs!) are indexed, and - if not - create the proper dedupe_* indices.

        Attachments

          Activity

            People

            • Assignee:
              amit Amiteshwar Prasad
              Reporter:
              shot Piotr Szotkowski
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: