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

Slow query in api / query object

          Details

          • Type: Bug
          • Status: Done/Fixed
          • Priority: Minor
          • Resolution: Duplicate
          • Affects Version/s: 4.7.9
          • Fix Version/s: Unscheduled
          • Component/s: None
          • Labels:
          • Versioning Impact:
            Patch (backwards-compatible bug fixes)
          • Documentation Required?:
            None
          • Funding Source:
            Needs Funding

            Description

            The Query object pointlessly wraps queries in LOWER - eg

            LOWER(civicrm_contribution.receive_date) BETWEEN "20150701000000" AND "20160630000000"

            This has performance implications but does not alter the effect of the query as case insensitive searches are the norm in mysql

              Attachments

                Activity

                  People

                  • Assignee:
                    eileen Eileen McNaughton
                    Reporter:
                    eileen Eileen McNaughton
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    1 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: