All Questions
Tagged with performance issues
5
questions
1
vote
1
answer
42
views
Change Log Tab Excrutiatingly Slow - Poorly Performing Query and Fix (from 8 minutes down to 4 seconds)
The page takes about 8 minutes to return which is absurdly slow for anything expected to be remotely interactive. It is so slow that my client is referring to it as the "Triangle of Doom".
I ...
- 223
1
vote
0
answers
52
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
4
votes
1
answer
55
views
Redundant Indexes
It looks like there are several redundant or partly redundant indexes that civicrm creates on the database. Some of this may be storage engine specific (e.g. InnoDB), but some isn't.
civicrm_contact:
...
- 223
5
votes
1
answer
69
views
Performance Bug in Trigger Causing ~1000x Slowdown
While looking for the root cause of a performance issue for a client, I tracked it down to a couple of triggers performing an inefficient UPDATE statement:
civicrm_activity_before_update
...
- 223
2
votes
3
answers
185
views
Using civi for big data sets (1 million plus)
I love civi! But mainly i use it for small datasets of sub 10,000
I have the opportunity to suggest its use in an organisation with a voter pool of 1 million+ I know this is an open ended question ...
- 799