Questions tagged [performance]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
2 answers
39 views

CiviCRM plugin causes a ~ 30 second login delay

Just upgraded to CiviCRM 5.54.1, on WordPress 6.0.3 (self-hosting on a virtual private host running CentOS 9, PHP 7.4.32 using php-fpm). For a really long time now, I think since the beginning to be ...
3 votes
3 answers
96 views

Tips for troubleshooting email performance

Tips for troubleshooting email performance. I have a CiviCRM instance that currently sends 800 emails an hour and I have the feeling that it can do better. Some details. CiviCRM 5.51.3 The CMS is ...
0 votes
1 answer
41 views

4 minutes to access admin page

I have a similar issue of the 2017 post first CiviCRM request of each session takes 4 minutes, afterwards works fine I have a fresh virtual server in a university saas, with wordpress 5.9.2, php 7.4, ...
  • 11
2 votes
1 answer
45 views

Slow smart group display on a contact after update to 5.46.3 from 5.35.x

When viewing the group tab of a contact, there's a "smart groups" openable tab, which triggers an ajax call to https://example.org/civicrm/contact/view/smartgroup?cid=youcontactid&...
  • 6,223
1 vote
1 answer
31 views

Heavy performance problem on 5.36 not related to query

I have an heavy problem on my Civicrm instance 5.36 on Wordpress 5.7.1 working in the backend, the time to open a dashobard is more the 20 seconds and every pages have similar time. By example: main ...
  • 121
0 votes
0 answers
28 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 ...
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 ...
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 ...
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: ...
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 ...
1 vote
0 answers
65 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....
  • 634
1 vote
0 answers
21 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 ...
  • 1,174
1 vote
1 answer
78 views

Civi is slowing down my website

Our website is hosted on Drupal 7 but is tied to our database in civi 5.14. We are experiencing a surge in new registrations which require people to fill out a full page of information that then gets ...
4 votes
3 answers
241 views

Contact export runs very slowly, creates huge temporary DB files

I was alerted to this problem when a contact export was performed that maxed out the 40GB of spare disk space and crashed the entire server. I found that exporting even a small number of contacts ...
  • 739
2 votes
1 answer
390 views

Error: more than 'max_user_connections' active connections

Several times a day on our Civi site (CiviCRM 5.11.0 with Drupal 7.64) we are experiencing the following error: PDOException: SQLSTATE[HY000] [1203] User xxx already has more than '...
  • 892
7 votes
2 answers
195 views

Preventing slow performance with smart groups

After doing some research (Capacity Planning), it appears as if Civi slows down when there are a lot of smart groups or if the smart groups are children of other groups. What should be some good ...
  • 369
3 votes
1 answer
86 views

What can be done to improve loading of Activity searches and tabs on databases with gazillion civicrm_activity_contact rows

Digging in to why one of our larger clients is suffering more from slowness of Activity searches or loading of Activity tab for contacts. Comparing it to other dbs what stands out for this database ...
  • 27.4k
3 votes
0 answers
71 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
3 answers
142 views

first CiviCRM request of each session takes 4 minutes, afterwards works fine

I have an issue where the first CiviCRM request of any session takes 4 minutes to load. This can be a request for the dashboard, or an administrative screen, it doesn't matter. There are no errors ...
  • 579
5 votes
3 answers
346 views

Performance Warning: Missing Indices. Mismatched Index Key

Just upgraded to 4.7.23 and am receiving a Performance Warning: Missing Indices. The warning states: The following tables have an index key with a mismatch in value. Please delete the key ...
  • 51
2 votes
4 answers
93 views

Capacity Planning

We would like to propose the utilization of CiviCRM in a big organization. They have 140.000 contacts, that manage more then 1.000.000 activities each year (including mails, contributions, etc), and ...
3 votes
3 answers
2k views

Is 1Gb memory enough for small server?

We have AmazonAWS t2.micro server (free tier). T2. micro has 1 Gb of ram and 1 vCPU. Only CiviCRM (4.7.14) is hosted there along with its Drupal. Currently the database is very small (less than 5000 ...
  • 1,012
4 votes
3 answers
421 views

Is CiviCRM resource intensive?

I need to plan requirements for multiple instances of CiviCRM as a Drupal module. My goal is to "more or less" know how many sites would I be able to put in a single application server (with ...
  • 179
1 vote
1 answer
130 views

Leaflet map + Drupal Views + 400 CiviCRM contacts data = performance?

We try to pull CiviCRM contacts data incl. multiply custom fields and display on map. There are around 400 contacts to display, yet map page loads a bit slower, than expected (5 to 10 seconds). It ...
  • 1,471
3 votes
1 answer
108 views

Slow loading of front end (public site) forms (profiles)

I'm experiencing slow loading times of civicrm forms at public site. For example, the form for bulletin suscribe takes about 20-30 seconds to load. You can check this here: http://londres38.cl/1937/...
5 votes
3 answers
483 views

How to speed up CiviCRM 4.7 php execution time

Anyone have an idea of how to speed up CiviCRM PHP execution time ? I'm an administrator of CiviCRM on Wordpress production set-up, and I find it too slow. I've conducted a little investigation using ...
5 votes
1 answer
236 views

How to reduce database bloat for faster upgrading?

In order to speed up slow upgrades, experienced folk (1 2) recommend reducing the size of the database to facilitate testing. What is the best way to declutter the database?
  • 1,561
3 votes
3 answers
175 views

How can I speed up a slow upgrade to 4.7?

Upgrades to 4.7 for big CiviCRM databases can take many many hours. What is the best way to speed them up?
  • 1,561
2 votes
3 answers
184 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 ...
5 votes
1 answer
750 views

Tweaking my.cnf for performance

Over the last year, with the help of mysqltuner, I've adjusted my.cnf to improve the performance of the 7 CiviCRM installations on my VPS. But in the last few days, as I upgraded my sites to 4.7.10, ...
  • 1,047
2 votes
2 answers
90 views

Major Performance Hit After 4.6 Upgrade

I recently upgraded from 4.4 to 4.6 using Drupal 7 and since then I have had some major performance problems (Search Builder responds to everything with a Timeout now.) Even simple queries for users ...
2 votes
2 answers
77 views

Full minute timeouts on first page load

I'm finding that when I first go to a CiviCRM page in the morning there's a loading time of just over 1 minute(!) There are no errors (on screen, nor in apache error log, nor in Drupal's watchdog) ...
  • 3,748
8 votes
6 answers
586 views

How can I improve the performance of the change log table?

Retrieving the change log for a contact takes ages for my client - maybe a response of 10 minutes to get just 79 records for one contact. The contact database has about 39K rows, but with about 950k ...
  • 4,453
2 votes
2 answers
377 views

What could be causing slow mailing from CiviCRM (via SMTP)

We're currently investigating why our mailings are sending slowly from CiviCRM. We use an external SMTP server. Our mailing settings: Mailer batch limit: 30000 Mailer throttle time: 2100 Mailer job ...
  • 1,912
4 votes
2 answers
438 views

Choosing a VPS solution for CiviCRM

I'm consistently maxing out my "MySQL Time" on my shared hosting provider (rhymes with MiviMosting), causing both my host and users to get upset. I'm pretty much tripling what I'm allowed to have on ...
  • 1,047
0 votes
2 answers
75 views

Upgrade to 4.6.6 : how to configure mysql server?

I upgraded Civicrm to 4.6.6 (next 4.6.7) and had a lot of problems since then. My sql server has started consuming much more memory while everything was allright before the upgrade with 512M of RAM. ...
  • 1
2 votes
1 answer
190 views

First CiviCRM API call is slower, are unnecessary resources loaded?

We're looking at importing a lot of data via the API call. But we've noticed that on a page load the first API call is significantly slower than following ones. Eg: $result = civicrm_api3('Contact', '...
  • 1,912
3 votes
1 answer
79 views

Can we disable resource-intensive logging queries triggered by inline edit?

On the contact summary page in CiviCRM 4.6.4 with advanced logging enabled, after doing an inline edit of address or phone, an AJAX query is triggered for a logging report URL: /civicrm/report/...
  • 2,355
14 votes
3 answers
521 views

Number of contacts vs. hosting space required

Apologies if these questions seem pretty elementary, but I am having a hard time finding definitive answers anywhere else on the web: 1) Is there a maximum number of contacts one can include in a ...