All Questions
Tagged with performance mysql
2
questions with no upvoted or accepted answers
3
votes
0
answers
73
views
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 ...
- 6,926
1
vote
0
answers
56
views
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 ...
- 223