CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Pre-installation Questions (Moderator: Dave Greenberg) »
  • Database Limits or Recommendations for Civicrm
Pages: [1]

Author Topic: Database Limits or Recommendations for Civicrm  (Read 1465 times)

Sandy.Ellingson

  • Guest
Database Limits or Recommendations for Civicrm
December 13, 2010, 06:59:13 pm
Are there recommended file sizes for the Civicrm database or suggested or recommended limits on the number of constituents or transactions a database should contain?  I have been told that Civicrm will not work for larger NFP's who may have as many as 750,000 active contacts with activities, donations and events occuring on regular basis.  This would be running on Drupal in a professional hosted environment with sufficient hardware and bandwidth.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Database Limits or Recommendations for Civicrm
December 13, 2010, 07:44:21 pm

Curious as to who gave you that information?

To a large extent, CiviCRM will scale as well as MySQL will scale (which is the underlying DB that CiviCRM uses). There will be a few places in CiviCRM where we generate non-optimal (or in some cases awful) queries, but those are usually fixable fairly easily.

There are some large orgs currently using CiviCRM. From our pingback stats, we've seen multiple orgs hold more than 1 million contacts and more than 0.5 million contributions. Some large orgs that are currently using CiviCRM with large data sets include:

New York State Senate (lots of contacts and activities)
Wikimedia foundation, Concern International (lots of contributions)
Alpha International (lots of contacts and contributions)
Various political parties around the world

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Sandy.Ellingson

  • Guest
Re: Database Limits or Recommendations for Civicrm
December 13, 2010, 08:40:58 pm
Thank you. This is just what I needed.

SandyEllingson

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 1
  • I want to make a difference!
    • Sandy Social Strategist
Re: Database Limits or Recommendations for Civicrm
December 20, 2010, 07:41:56 am
A data hosting company that has some open source programmers and reviewed our RFP as well as another vendor.  We are several months down the road with implementing Civicrm, but now working with a new hosting company.  I understand that everyone has their preferences and that alot of this is a matter of personal opinion or what you are use too. What I am really looking for is confirmation that Civicrm running on a mysql/drupal platform is running successfully with other large volume installations.  Within a year our goal is to have 1 million records within the contacts and generating 100,000 events a year. 

I am committed to Civicrm and believe it to be a valid solution. Is there actual track records or history of clients at this level using the system successfully? If so, are there requirements to successfully do that.

Thanks for the response.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Pre-installation Questions (Moderator: Dave Greenberg) »
  • Database Limits or Recommendations for Civicrm

This forum was archived on 2017-11-26.