Questions tagged [performance]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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 ...
1
vote
1answer
37 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
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 ...
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: ...
5
votes
1answer
58 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
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 ...
1
vote
1answer
65 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
3answers
221 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 ...
2
votes
1answer
229 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 '...
7
votes
2answers
174 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 ...
3
votes
1answer
80 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 ...
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
3answers
109 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 ...
5
votes
3answers
344 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 ...
2
votes
4answers
90 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
3answers
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 ...
4
votes
3answers
364 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 ...
1
vote
1answer
120 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 ...
3
votes
1answer
104 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
3answers
459 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
1answer
199 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?
3
votes
3answers
172 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?
2
votes
3answers
167 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
1answer
699 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, ...
2
votes
2answers
88 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
2answers
75 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) ...
8
votes
6answers
523 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 ...
2
votes
2answers
345 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 ...
4
votes
2answers
402 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 ...
0
votes
2answers
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. ...
2
votes
1answer
179 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', '...
3
votes
1answer
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/...
14
votes
3answers
507 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 ...