Details
-
Type: Patch
-
Status: Done/Fixed
-
Priority: Major
-
Resolution: Fixed/Completed
-
Affects Version/s: 3.3.6
-
Fix Version/s: 3.4.6
-
Component/s: Core CiviCRM
-
Labels:None
Description
Adds MyISAM storage engine specification to the queries that create temporary tables are part of the dedupe process. Without this specification a civicrm install using default_storage_engine = InnoDB dedupes much slower because of how much slower InnoDB temporary tables are than MyISAM tables (especially with the file_per_table option).