Details
-
Type: Sub-task
-
Status: Done/Fixed
-
Priority: Trivial
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.2.9, 4.3.3
-
Fix Version/s: 4.4.0
-
Component/s: Core CiviCRM
-
Labels:None
Description
The default quicksearch and empty basic search generate a query which uses
is_deleted = 0 ORDER BY sort_name
mysql needs an index on is_deleted and sort_name to avoid doing a filesort. Adding this index should optimize this path