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 »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Performance problem
Pages: [1]

Author Topic: Performance problem  (Read 799 times)

Simon147

  • I post occasionally
  • **
  • Posts: 96
  • Karma: 3
  • CiviCRM version: 4.4.6
  • CMS version: Drupal 7.30
  • MySQL version: 5.0.92
  • PHP version: 5.2.9
Performance problem
August 10, 2010, 07:21:16 am
Hello,

I'm testing a community website using Drupal and Civicrm (v. 3.1.7). I currently have some serious performance problems with the server taking regularly more than just a few seconds to respond. The site is hosted on a shared server account (bluehost.com) where I can see that the server is constantly throttling the site.

I'm not an IT geek, so I am not sure if it is just normal that civicrm uses that much resources or if something is not as it should be.

There is only one point that might be a cause: I have tried to install localization support, but not supporting trigger, this did obviously not work. However, since I have tried that, the database containes tables for each language (EN, DE, IT and FR). Would this be a cause for the slow speed? And could I do something to speed it up? Can I simply delete the tables of the languages that I can't use since Trigger is not activated?

Thanks a lot for any help.

Simon

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: Performance problem
August 10, 2010, 09:42:22 am

in general for most production uses we do not recommend that you run on a shared server. Its definitely worth it to spend at least $20+ and get a better hosting provider. CiviCRM is resource intensive (but then again, i suspect most/all CRM's are)

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

Simon147

  • I post occasionally
  • **
  • Posts: 96
  • Karma: 3
  • CiviCRM version: 4.4.6
  • CMS version: Drupal 7.30
  • MySQL version: 5.0.92
  • PHP version: 5.2.9
Re: Performance problem
August 11, 2010, 08:38:28 am
My database currently counts 10 contacts and nothing else except the standard content and I have about 5 visits per day on that webpage. So I guess there must still be a performance problem.

Simon

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Performance problem
August 11, 2010, 08:48:15 am
The problem isn't on civicrm (not as this low level of contacts at least), but more likely your host that isn't good enough.


X+
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

CityBloc

  • I post occasionally
  • **
  • Posts: 38
  • Karma: 0
  • CiviCRM version: 4.4.6
  • CMS version: WordPress 3.9.2
  • MySQL version: 5.5.37
  • PHP version: 5.3.10
Re: Performance problem
August 12, 2010, 02:42:02 pm
Quote from: Simon147 on August 11, 2010, 08:38:28 am
My database currently counts 10 contacts and nothing else except the standard content and I have about 5 visits per day on that webpage. So I guess there must still be a performance problem.

Database record count, table count and site visit count are just three of several parameters that "weigh down" any host and contribute to making the applications installed upon it slow to respond.  

The biggest problem with your choice of shared host model is that shared hosting takes that long list of demands upon the system and multiplies it (by the number of customers hosted upon the shared resources.)

VPS is far better than shared hosting for two reasons:

1) there is only one list of demands per system, meaning you remain effectively in control of application responsivity
2) when you run low on resources (RAM, disk) you can add more with only a credit card, a web form and a reboot

-r


« Last Edit: August 12, 2010, 02:46:03 pm by Rob Warmowski »
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Performance problem

This forum was archived on 2017-11-26.