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

Improve Query Speeds on large datasets by removing Lower Function from Query.php

    Details

    • Versioning Impact:
      Patch (backwards-compatible bug fixes)
    • Documentation Required?:
      None
    • Funding Source:
      Needs Funding

      Description

      Gets rid of apparently unnecessary "lower" function in core query code that, when used against indexed fields in large datasets, un-indexes the field slowing the MySQL query speed dramatically. When removed, large searches that take minutes are reduced to low single digit seconds. See listing of statements in Query.php to be updated in attached diff file from v4.0.6.

        Attachments

          Activity

            People

            • Assignee:
              colemanw Coleman Watts
              Reporter:
              civifan2012 Kevin Hoar
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: