Answers.Body: <p>since this seems to be a question specifically about 'scaling and performance' there have been some other posts about this type of issue eg</p>
  
  <p><a href="https://civicrm.stackexchange.com/questions/15012/using-civi-for-big-data-sets-1-million-plus/15014#15014">Using civi for big data sets (1 million plus)</a></p>
  
  <p>You can also see some stats here: <a href="https://stats.civicrm.org/?tab=sites" rel="nofollow noreferrer">https://stats.civicrm.org/?tab=sites</a> showing more than 150 sites with over 250000 contacts in them.</p>
  
  <p>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.</p>
  
  <p>Eg using a lot of Smart Groups, or worse parent-child Smart Groups, can definitely slow things down.</p>
  
  <p>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.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-02-04T20:38:25.720Z
Answers.Text: 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
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-02-04T20:36:32.157Z
Answers.LastActivityDate: 2019-02-04T20:36:32.157Z
Answers.UserDisplayName: petednz - fuzion
Answers.Body: <p>Welcome to Stack Exchange,</p>
  
  <p>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).</p>
  
  <p>If you are interested, please send me a message and I could connect you with someone there.  </p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-02-05T07:17:37.340Z
Answers.LastActivityDate: 2019-02-05T07:17:37.340Z
Answers.UserDisplayName: Fabian
Body: <p>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.</p>
  
Tags: <sales>
Title: CiviCRM References
ThreadText: # CiviCRM References
  
  (Asked by: username_0 on 2019-02-04)
  
  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.
  
  **Tags:** sales
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2019-02-04. Score: 2 | Accepted answer
  
  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)](https://civicrm.stackexchange.com/questions/15012/using-civi-for-big-data-sets-1-million-plus/15014#15014)
  
  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, username_1, 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.
  
  > **Comments:**
  > **username_1**: 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  
  
  ---
  
  ### Answer by username_2 on 2019-02-05. Score: 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.
  
  
  ---
  
  