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

Name&email search is not using indexes correctly

    Details

    • Documentation Required?:
      None
    • Funding Source:
      Contributed Code

      Description

      If you DESCRIBE the generated queries, you'll see that it is doing filesort in two places. This makes search unusable for our dataset. Our preferences are: Include email ON; all other options OFF.

        Attachments

        1. perf.jpg
          22 kB
          Eileen McNaughton
        2. queries.txt
          7 kB
          Eileen McNaughton

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              adamw Adam Wight
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: