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 »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Should I use a separate database for CiviCRM?
Pages: [1]

Author Topic: Should I use a separate database for CiviCRM?  (Read 1388 times)

davo

  • Guest
Should I use a separate database for CiviCRM?
February 04, 2008, 01:09:57 am
I've got an existing Drupal website for a sporting club. Most of the usage on the site is around posts, images, video, etc. I'm looking to add CiviCRM to assist with registration. So we want to store lots of info about our members who are players. There will be a flurry of CiviCRM activity around the start of the season when registration takes place. After that there will be occasional admin type stuff. The Drupal website will probably get most of the load.

One other thing, we're using Profiles so when the user edits their Drupal account some of the data is saved through to CiviCRM tables.

I'm wondering if I should have my CiviCRM data in a separate database (given the above). Would anyone care to make a recommendation.

I've got a test site running on a single database and it seems fine. But it's getting nothing like the real site's load. There's about 60 or so Drupal tables and 80 or so CiviCRM tables all in the on database.

PS: Drupal 5.x, CiviCRM 1.9.x, MySQL 5.0.x

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: Should I use a separate database for CiviCRM?
February 04, 2008, 02:00:20 am

I'm a bit biased, but i'd recommend two different databases, primarily because its two different open source projects and each of the databases are quite large (with regard to schema). I'm not sure if there is a difference with having one or two db's from a performance perspective (i suspect not)

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
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Should I use a separate database for CiviCRM?

This forum was archived on 2017-11-26.