Questions tagged [performance]
The performance tag has no usage guidance.
39
questions
0
votes
2
answers
68
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
206
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 ...
- 3,183
0
votes
1
answer
62
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
50
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,644
1
vote
1
answer
35
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 ...
- 141
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 ...
- 133
1
vote
1
answer
47
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
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
4
votes
1
answer
58
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
93
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
1
vote
0
answers
101
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
23
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,236
1
vote
1
answer
93
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 ...
- 11
4
votes
3
answers
269
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
447
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
'...
- 934
7
votes
2
answers
210
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
88
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 ...
- 28.1k
3
votes
0
answers
74
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,936
1
vote
3
answers
155
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 ...
- 559
5
votes
3
answers
351
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
98
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 ...
- 21
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,044
4
votes
3
answers
469
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
137
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,839
3
votes
1
answer
119
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
507
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 ...
- 51
5
votes
1
answer
259
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,571
3
votes
3
answers
179
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,571
2
votes
3
answers
191
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 ...
- 809
5
votes
1
answer
778
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
94
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 ...
- 213
2
votes
2
answers
82
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,910
8
votes
6
answers
606
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,720
2
votes
2
answers
403
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,922
4
votes
2
answers
469
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
199
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,922
3
votes
1
answer
82
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,365
14
votes
3
answers
538
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 ...
- 141