6 votes
Accepted

Is CiviCRM resource intensive?

It's tempting to discard this question as being too vague to give an accurate answer to, but capacity planning is a real and difficult challenge. Is CiviCRM resource intensive? That depends what you ...
Aidan's user avatar
  • 13.2k
6 votes
Accepted

How to reduce database bloat for faster upgrading?

Best to review the tables which are largest in your DB, and also identify which queries during the upgrade take the longest. This is a chicken-and-egg problem, which means you might review the tables ...
Chris Burgess's user avatar
6 votes
Accepted

How can I speed up a slow upgrade to 4.7?

The slowest part of upgrading on a large installation is usually the civicrm_mailing_event_* tables. That data is also often stale, so consider deleting it if you don't need to keep historical ...
Jon G - Megaphone Tech's user avatar
4 votes
Accepted

Full minute timeouts on first page load

This problem is not to do with CiviCRM. My server defaults to using ipv6 but this is not configured. Therefore when CiviCRM tries a file_get_contents('http...') it is timing out. This vexed me for a ...
artfulrobot's user avatar
  • 3,920
4 votes

How can I speed up a slow upgrade to 4.7?

For the specific case of upgrading to 4.7, here's a useful tip from Dave Jenkins : https://issues.civicrm.org/jira/browse/CRM-18526#comment-106825 In short: upgrading to 4.7 involves multiple changes ...
Alan Dixon's user avatar
  • 6,766
4 votes
Accepted

Performance Bug in Trigger Causing ~1000x Slowdown

Nice find. Thanks for posting. Yes the inner join is generally better than a subquery. To answer your secondary question, to get it merged you need to create a ticket at https://lab.civicrm.org/dev/...
Demerit's user avatar
  • 22.4k
3 votes

Capacity Planning

There are certainly instances with much larger numbers of contacts than you are describing. We have several in the range of .5-1 million contacts and of course the associated activities etc. And there ...
petednz - fuzion's user avatar
  • 28.2k
3 votes

How can I speed up a slow upgrade to 4.7?

Consider moving your MySQL folder to a RAM disk. This is NOT recommended for a production upgrade, but could speed a dev/test site upgrade! See here for a script. Folks often report a 50x speedup - ...
Jon G - Megaphone Tech's user avatar
3 votes

How to speed up CiviCRM 4.7 php execution time

If you're lucky, you just need to turn on the php op-code cache. My experience using on Centos6 was that it wasn't on by default. But I'm intrigued if your slow execution time is specific to CiviCRM. ...
Alan Dixon's user avatar
  • 6,766
3 votes

How to speed up CiviCRM 4.7 php execution time

This would appear to be a fairly general question of Linux server optimization, which is a complicated subject. The details of such optimization depend on a myriad of factors and settings and is, ...
Hershel's user avatar
  • 735
3 votes

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

For people googling, I significantly increased the speed of the Change Log by following Eileen's advice in her answer: convert some tables (activity, activity_contact, contact, group, group_contact) ...
Andrew West's user avatar
  • 2,019
3 votes
Accepted

Preventing slow performance with smart groups

Do you have a few smart groups on which many others depend? If so it's worth making sure they're as quick as possible. We have a script that generates the important ones once per hour - but by putting ...
Andrew West's user avatar
  • 2,019
2 votes

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

Take a look at the INNODB logging extension. It converts the log table format from ARCHIVE to INNODB, adding indexes and speeding up as a result.
michaelmcandrew's user avatar
2 votes

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

The log tables as originally implemented (I have checked for a few years if this is the case) also contain a large number of superfluous records due to writes that don't actually change the data. ...
Joe Murray's user avatar
  • 6,741
2 votes

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

There are a couple of points to this. 1 - SMTP is chatty, it is a fairly slow protocol. To combat this, run several mailing jobs in parallel. This can be achieved by calling the process_mailing cron ...
John's user avatar
  • 1,922
2 votes

Using civi for big data sets (1 million plus)

Skvare has worked with a number of CiviCRM implementations with data sets of significant size. As has been mentioned, do expect to have a bit of a "learning" curve - especially with the LAMP stack ...
Peter Petrik's user avatar
2 votes

Using civi for big data sets (1 million plus)

CiviCRM handles large datasets fine. There are 100+ sites with more than 250k contacts (https://stats.civicrm.org/?tab=sites). You will need to ensure that the server used is powerful enough. To ...
Joe Murray's user avatar
  • 6,741
2 votes

Using civi for big data sets (1 million plus)

I've never used Civi with a dataset that large, but there are some general scaling principles that apply to Civi as with any other system. The most important one I learned is that work = size * ...
Alan Dixon's user avatar
  • 6,766
2 votes

Tweaking my.cnf for performance

First you should fix "Total fragmented tables: 868". And it does seem your amount of RAM is too small. But you could first increase innodb_buffer_pool_size to 2.5GB and join_buffer_size to 16M ...
Catorghans's user avatar
  • 3,544
2 votes

Is CiviCRM resource intensive?

@Aidan is right - there is no one number for how many sites - not even a 'more or less' number :-) Some of our projects are on one dedicated server that hosts a couple dozen of them; they are all ...
KarinG - Semper IT's user avatar
2 votes

Major Performance Hit After 4.6 Upgrade

You may be running into performance issues if you have groups in your Search Builder queries. See CRM-16483.
Jon G - Megaphone Tech's user avatar
2 votes

Capacity Planning

Several organizations use CiviCRM with similar needs. Wikimedia Foundation and Australian Green Party have very similar requirements, for example.
Jon G - Megaphone Tech's user avatar
2 votes

Performance Warning: Missing Indices. Mismatched Index Key

I suggest you delete the UI_case_contact_id index as suggested by CiviCRM, and then refresh the system status page. It should then present a button which will automatically add missing indexes.
Coleman's user avatar
  • 18.2k
2 votes

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

I had a lot of trouble tracking down a problem that sounds the same. We ARE behind a firewall so pingbacks to CiviCRM etc WILL timeout. The last piece of the puzzle (once normal version checks were ...
user4278's user avatar
  • 1,021
2 votes

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

I do not know why this is so slow but we developed an extension together with Matthew Wire that improves some of those problems. Information can be found here.
Fabian's user avatar
  • 3,527
2 votes
Accepted

Contact export runs very slowly, creates huge temporary DB files

MySQL is forced to generate temporary tables when the query contains GROUP_CONCAT (among other reasons), which this query does in order to capture all values of groups, tags and notes into single ...
BobS's user avatar
  • 739
2 votes

Civi is slowing down my website

You're on an insecure version of CiviCRM, you'll want to update it. Page caching is not going to help, because form interaction is not (page) cached. I'll assume you've got the usual production ...
Alan Dixon's user avatar
  • 6,766
2 votes

Redundant Indexes

To reduce apparently "unanswered" questions... The answer here is: yes, you're right, good catch! The suggestions that relate to CiviCRM core have been acted upon, thanks for contributing! ...
artfulrobot's user avatar
  • 3,920
2 votes

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

Short answer: yes. As per Demerit's link to the existing issue, it's related to a recent change in CiviCRM core that tries to be smarter when presenting the unsubscribe form. For non-obvious reasons, ...
Alan Dixon's user avatar
  • 6,766
2 votes

Tips for troubleshooting email performance

I found the culprit. It was CiviRules. In the system, a rule configured on activity with a complicated test. For every e-mail sent, a mass mail activity is created and the activity rule fires. ...
Kainuk - CiviCooP's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible