Details
-
Type:
Improvement
-
Status: Done/Fixed
-
Priority:
Critical
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.4.0
-
Fix Version/s: 4.4.1
-
Component/s: None
-
Labels:None
Description
CRM/Report/Form/Activity.php
it currently LEFT JOINS: civicrm_activity_contact and civicrm_contact 3 times each (once each for source, target and assignee)
BUT with the new structure we can do:
1 INNER JOIN between civicrm_activity, civicrm_activity_contact and civicrm_contact and get all the data as above (although in multiple rows which we'll need to collapse outside of sql)
this will be far far more efficient, if a site has lots of activities and contacts.