Tagged with performance mysql
2 questions with no upvoted or accepted answers
Activity Tab takes much time to load on civi 4.7.29
The activity tab on the contact summary page takes much time to load and list the activities. Below is the time-consuming query which takes around 20-25 sec each for the contacts having ~50 activity ...
Poorly performing unindexed query on log tables
While investigating a CiviCRM performance issue, I came across this query: SELECT * FROM `civicrm`.`log_civicrm_activity_contact` WHERE log_conn_id = ? AND id = ? ORDER BY log_date DESC limit ...