Questions tagged [performance]

The tag has no usage guidance.

7 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4
votes
0answers
46 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: ...
3
votes
0answers
68 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 ...
1
vote
0answers
42 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 ...
1
vote
0answers
26 views

What are your typical mail size batches and delviery times?

What are your typical mail sizes and time to complete mail job? Looking for comparisons... We are having lots of mail delivery problems on a new highly customised install of Civi v5.27.1 (MariaDB v10....
1
vote
0answers
18 views

How do I manage a database with millions of mail recipient records when searching on opens or click throughs?

We are working with a group that sends tens of thousands of mailings on a weekly basis so the civicrm_mailing_recipient (and related tables) have millions of records. They also want to track opens and ...
0
votes
0answers
22 views

performance of business functions

We have been using civi live for a few months in a hosted environment. In response to concerns from the admin team I took some timings for common tasks and agree with them that performance is very ...
0
votes
0answers
33 views

Slow Query Fixes - MSP, Custom Searches

I ran into the following problematic queries while troubleshooting CiviCRM performance issues. insert into civicrm_prevnext_cache (cachekey, entity_id1, data) SELECT DISTINCT 'civicrm search ...