Details
-
Type: Improvement
-
Status: Done/Fixed
-
Priority: Important
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.7.15, 4.7.16, 4.7.17, 4.7.18, 4.7.19
-
Fix Version/s: 4.7.25
-
Component/s: Core CiviCRM
-
Labels:
-
Versioning Impact:Patch (backwards-compatible bug fixes)
-
Documentation Required?:None
-
Funding Source:Contributed Code
-
Verified?:Yes
Description
Contacts with a lot of relationships (over 5000) take a lot of time to load. This is because the count of relationships is being done by fetching ALL records of relationships associated to the contact from the Database, putting them into an array, and then counting the number of elements in the array.
This is the problematic code:
https://github.com/civicrm/civicrm-core/blob/4.7.19/CRM/Contact/BAO/Contact.php#L2573-L2579
This problem was also reported in CRM-6628.
Attachments
Issue Links
- links to