Details
-
Type:
Bug
-
Status: Done/Fixed
-
Priority:
Trivial
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.7.11
-
Fix Version/s: 4.7.19
-
Component/s: None
-
Labels:
-
Versioning Impact:Patch (backwards-compatible bug fixes)
-
Documentation Required?:None
-
Funding Source:Needs Funding
Description
I have observed a number of slow queries that look like this
SELECT email_id
FROM civicrm_mailing_event_queue
WHERE ( civicrm_mailing_event_queue.hash = '3716e8cc4292a041' )
It turns out that despite being a large table there is no index on the hash field - this is used when people click on things like unsubscribe