1

We are a medium-sized non profit religious organization and are looking to see what CIVICRM can do for us. We are just looking to speak to other users or organizations our size ($10M budget give or take) to hear about how they use Civi and what their experiences have been like. Is that something you all can offer or direct us to the right folks? We have about 2 million contact records and dont want to dump them in to CIVI if it is going to be unusable because of the sheer size of our database.

2

since this seems to be a question specifically about 'scaling and performance' there have been some other posts about this type of issue eg

Using civi for big data sets (1 million plus)

You can also see some stats here: https://stats.civicrm.org/?tab=sites showing more than 150 sites with over 250000 contacts in them.

We, Fuzion, and several other providers will have worked with large datasets. Each site is still a bit 'unique' in terms of where you might need to address performance issues.

Eg using a lot of Smart Groups, or worse parent-child Smart Groups, can definitely slow things down.

There are some internal settings such as for Search Preferences which you can tweak to improve performance, but clearly a fundamental issue is about the server's capabilities.

  • Other tweaks that can be deployed include using pt-kill which can terminate any sql queries that run for too long to avoid them making life hard for other db users – petednz - fuzion Feb 4 at 20:38
1

Welcome to Stack Exchange,

Greenpeace's Central Europe Branch is using CiviCRM and has a similarly sized contact base. As expected a couple of tweaks and adaptions were necessary for the system to run smoothly (such as not using smart groups).

If you are interested, please send me a message and I could connect you with someone there.

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.