Answers.Body: <p>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 are others out there much larger than those.</p>
  
  <p>If it performance you are concerned about, rather than the number of rows in tables like _contact and _activities, the issues will more likely be around usage of Smart Groups and other query demanding features, especially if nesting of queries is involved.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-05-19T06:19:23.520Z
Answers.LastActivityDate: 2017-05-19T20:38:28.737Z
Answers.LastEditDate: 2017-05-19T20:38:28.737Z
Answers.UserDisplayName: petednz - fuzion
Answers.Body: <p>Several organizations use CiviCRM with similar needs.  Wikimedia Foundation and Australian Green Party have very similar requirements, for example.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-05-18T17:06:49.580Z
Answers.LastActivityDate: 2017-05-18T17:06:49.580Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.Body: <p>We have about 1 million contacts now (grown from 50k to 1 million over 3 years) and have millions of activities.  We are now using the full CiviMail to replace external email marketing systems which will greatly increase activities.  We use complete contribution management and event management, we are now doing much more volunteer management which will also increase activities.  </p>
  
  <p>We moved from shared server, to virtual private server, to outsourcing hosting to a Civi service provider because of performance issues and lack of server expertise.  If you have the server (or cloud) knowledge you could do it yourself.</p>
  
  <p>We are just beginning to incorporate some complex smart groups and will see if they impact performance.</p>
  
  <p>The organizational structure and ACLs are more complicated and I would recommend getting experienced advice. </p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-05-28T09:12:17.703Z
Answers.Text: I'm curious about the specs of your VPS. Could you tell us more about it? Thanks.
Answers.UserDisplayName: AlainB
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-05-29T10:09:40.010Z
Answers.Text: It was on GoDaddy.  We started with 3GB of memory and finished with 8GB memory.  We also upgraded to the max amount of available resources that GoDaddy offered.  I have no other parameters.  I do not know enough about the server setup and the stack to know if our issues with the server were because of me and lack of knowledge or the server size.
Answers.UserDisplayName: Ron Gridley
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-04-06T21:04:40.467Z
Answers.Text: Just a note that the outsourcing company (Fuzion) have this site running on a 12 GB Linode
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-05-20T12:19:29.443Z
Answers.LastActivityDate: 2017-05-20T12:19:29.443Z
Answers.UserDisplayName: Ron Gridley
Answers.Body: <p>It is our experience too that if there are performance problems with our bigger customers they tend to be caused by Smart Groups</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-05-19T07:51:21.633Z
Answers.LastActivityDate: 2017-05-19T07:51:21.633Z
Answers.UserDisplayName: ErikH - CiviCooP
Body: <p>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 they need to use ACL for 3 different level: holding, country, organization.
  Have someone experience about CiviCRM with these figures?</p>
  
  <p>Thanks a lot </p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-05-19T10:05:25.807Z
Comments.Text: See also similar questions: https://civicrm.stackexchange.com/questions/18503/is-1gb-memory-enough-for-small-server https://civicrm.stackexchange.com/questions/18355/is-civicrm-resource-intensive?noredirect=1&lq=1 https://civicrm.stackexchange.com/questions/6467/choosing-a-vps-solution-for-civicrm?noredirect=1&lq=1 https://civicrm.stackexchange.com/questions/17191/new-to-civicrm-hosting-vps-requirements-and-migration-from-nationbuilder?rq=1 https://civicrm.stackexchange.com/questions/3287/number-of-contacts-vs-hosting-space-required?rq=1
Comments.UserDisplayName: Chris Burgess
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-05-19T20:41:53.773Z
Comments.Text: good chasing. i saw one of these was tagged as 'performance' so I tagged all of them as such though I underestand it may not be 'the' term that best links these types of questions. If anyone can think of other, or better, eg 'scaling', go ahead
Comments.UserDisplayName: petednz - fuzion
Tags: <database><acl><performance>
Title: Capacity Planning
ThreadText: # Capacity Planning
  
  (Asked by: username_0 on 2017-05-18)
  
  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 they need to use ACL for 3 different level: holding, country, organization.
  Have someone experience about CiviCRM with these figures?
  
  Thanks a lot
  
  **Tags:** database, acl, performance
  
  > **Comments:**
  > **username_1**: See also similar questions: https://civicrm.stackexchange.com/questions/18503/is-1gb-memory-enough-for-small-server https://civicrm.stackexchange.com/questions/18355/is-civicrm-resource-intensive?noredirect=1&lq=1 https://civicrm.stackexchange.com/questions/6467/choosing-a-vps-solution-for-civicrm?noredirect=1&lq=1 https://civicrm.stackexchange.com/questions/17191/new-to-civicrm-hosting-vps-requirements-and-migration-from-nationbuilder?rq=1 https://civicrm.stackexchange.com/questions/3287/number-of-contacts-vs-hosting-space-required?rq=1  
  > **username_2**: good chasing. i saw one of these was tagged as 'performance' so I tagged all of them as such though I underestand it may not be 'the' term that best links these types of questions. If anyone can think of other, or better, eg 'scaling', go ahead  
  
  ---
  
  ## 4 answers
  
  ### Answer by username_2 on 2017-05-19. Score: 3
  
  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 are others out there much larger than those.
  
  If it performance you are concerned about, rather than the number of rows in tables like \_contact and \_activities, the issues will more likely be around usage of Smart Groups and other query demanding features, especially if nesting of queries is involved.
  
  
  ---
  
  ### Answer by username_3 on 2017-05-18. Score: 2
  
  Several organizations use CiviCRM with similar needs. Wikimedia Foundation and Australian Green Party have very similar requirements, for example.
  
  
  ---
  
  ### Answer by username_4 on 2017-05-20. Score: 1
  
  We have about 1 million contacts now (grown from 50k to 1 million over 3 years) and have millions of activities. We are now using the full CiviMail to replace external email marketing systems which will greatly increase activities. We use complete contribution management and event management, we are now doing much more volunteer management which will also increase activities.
  
  We moved from shared server, to virtual private server, to outsourcing hosting to a Civi service provider because of performance issues and lack of server expertise. If you have the server (or cloud) knowledge you could do it yourself.
  
  We are just beginning to incorporate some complex smart groups and will see if they impact performance.
  
  The organizational structure and ACLs are more complicated and I would recommend getting experienced advice.
  
  > **Comments:**
  > **username_5**: I'm curious about the specs of your VPS. Could you tell us more about it? Thanks.  
  > **username_4**: It was on GoDaddy.  We started with 3GB of memory and finished with 8GB memory.  We also upgraded to the max amount of available resources that GoDaddy offered.  I have no other parameters.  I do not know enough about the server setup and the stack to know if our issues with the server were because of me and lack of knowledge or the server size.  
  > **username_2**: Just a note that the outsourcing company (Fuzion) have this site running on a 12 GB Linode  
  
  ---
  
  ### Answer by username_6 on 2017-05-19. Score: 0
  
  It is our experience too that if there are performance problems with our bigger customers they tend to be caused by Smart Groups
  
  
  ---
  
  