Details
-
Type:
Bug
-
Status: Done/Fixed
-
Priority:
Minor
-
Resolution: Incomplete
-
Affects Version/s: 4.3.4
-
Fix Version/s: Unscheduled
-
Component/s: Core CiviCRM
-
Labels:None
-
Documentation Required?:None
-
Funding Source:Needs Funding
Description
Hi,
We have a large dataset of contacts (100k+) - and the dedupe process takes a while to execute.
Unfortunately, it takes so long that other operations are failing due to lock timeout (SQL for dedupe takes 15-20 min to return). For example API contact inserts, or UI contact inserts.
Obviously this is problematic.
Is it possible to make the dedupe query non-locking on the contacts table?