Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [performance]

The tag has no usage guidance.

7
votes
2answers
102 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
52 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
50 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
82 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 ...
0
votes
0answers
16 views

How does one delete “key indices”? [duplicate]

After upgrading to 7.2.4, I get this message: Performance warning: Missing indices The following tables have an index key with a mismatch in value. Please delete the key indices listed from ...
5
votes
3answers
265 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
71 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
466 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 ...
2
votes
3answers
138 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
90 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
86 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/...
6
votes
3answers
318 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
126 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?
4
votes
3answers
155 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
103 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
376 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, ...
3
votes
2answers
83 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
64 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
288 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 ...
1
vote
2answers
235 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
302 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
68 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
155 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
72 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
430 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 ...