Details
-
Type: Improvement
-
Status: Done/Fixed
-
Priority: Minor
-
Resolution: Duplicate
-
Affects Version/s: 4.2.9
-
Fix Version/s: Unscheduled
-
Component/s: Core CiviCRM
-
Labels:
-
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.