Details
-
Type: Patch
-
Status: Done/Fixed
-
Priority: Minor
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.4.14
-
Fix Version/s: 4.6.3
-
Component/s: Core CiviCRM
-
Documentation Required?:None
Description
Just as civicrm_mailing_event_* tables were excluded from logging in CRM-12300, I think it would make sense also to exclude civicrm_mailing_recipients. This gets cleared & repopulated in CRM_Mailing_BAO_Mailing::getRecipients().
I saw an example recently where a mailing with 73k recipients had 1.2 million entries in log_civicrm_mailing_recipients, just for that mailing (92 million in total in that table). That's an awful lot of inserts and MySQL was struggling.
Would be good to get this into 4.4.x LTS.
Attachments
Issue Links
- supplements
-
CRM-12300 Do no log civicrm_mailing_event_* tables
- Done/Fixed