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) »
  • Speeding up CiviCRM
Pages: [1]

Author Topic: Speeding up CiviCRM  (Read 4570 times)

joshathedone

  • I post occasionally
  • **
  • Posts: 50
  • Karma: 0
  • CiviCRM version: Civicrm4
  • CMS version: Drupal 7
  • MySQL version: 5.1.41
  • PHP version: 5
Speeding up CiviCRM
January 06, 2012, 03:38:47 pm
I am administering a site that is running CiviCRM 4.0.8 on Drupal 7.  I finally have everything running and configured and everything is great except for one problem.  CiviCRM is running SLOW.  Annoying, bordering on unusable slow.  I don't understand where the problem is coming from because the Drupal side of my site is downright snappy, even the largest pages with embedded media and the like load several times faster then the smallest Civi page. 

I have not yet had a chance to play with tweaking my.cnf, but I'm not sure how helpful that is going to be.  If the root of this problem lies in the sql configuration I would not expect to see query-heavy drupal pages load far faster then CIvi pages with almost no content.  As an example, if I type a name in the quick search bar I have to wait well over ten seconds to get a result.  I currently only have four contacts

I'm sure the problem lies somewhere in my site as the test sites here are quite speedy and usable; but I'm running out of ideas.  Can anyone suggest where I can look or what steps I can take to try and solve this problem?  I'm more than willing to get any necessary information and post it here.     

Thanks in advance.

joshathedone

  • I post occasionally
  • **
  • Posts: 50
  • Karma: 0
  • CiviCRM version: Civicrm4
  • CMS version: Drupal 7
  • MySQL version: 5.1.41
  • PHP version: 5
Re: Speeding up CiviCRM
January 06, 2012, 04:04:31 pm
To give an idea - my home page which has some content, pictures, a js driven slider, and social media buttons is loading in about 2.5 seconds.  My CiviCRM dashboard, which is currently empty, is taking around 13 seconds to load.

FrTommy

  • I post frequently
  • ***
  • Posts: 273
  • Karma: 2
  • CiviCRM version: 4.5.x
  • CMS version: Drupal 7.x
  • MySQL version: 5.5.32
  • PHP version: 5.3
Re: Speeding up CiviCRM
January 07, 2012, 05:21:58 pm
Same here josh. civicrm has always been extremely SLOW since I've been using it. My drupal site is snappy as well. All I've ever been told is to upgrade to a better server.....that doesn't seem like a feasible answer since the drupal side works perfectly. In my opinion it's a civi issue.

joshathedone

  • I post occasionally
  • **
  • Posts: 50
  • Karma: 0
  • CiviCRM version: Civicrm4
  • CMS version: Drupal 7
  • MySQL version: 5.1.41
  • PHP version: 5
Re: Speeding up CiviCRM
January 07, 2012, 05:25:48 pm
Well I may have found a partial answer.  On a hunch, I disabled my memcache integration in civicrm.settings.php.  It seems as though it may have largely fixed the problem.  Something may be wrong in my memcahce config.  I'll post back after I have had the chance to test some.

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: Speeding up CiviCRM
January 08, 2012, 12:46:02 pm

hmm thats wierd. the only way memcache would slow things down would be to accept a request and not respond really quickly (i.e. delay the response). would be great if you can figure out what happened and why

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

mtvoters

  • I’m new here
  • *
  • Posts: 1
  • Karma: 0
  • CiviCRM version: 4.1.6
  • CMS version: Drupal 6
  • MySQL version: 5.0.51a
  • PHP version: unsure
Re: Speeding up CiviCRM
October 04, 2012, 10:57:20 am
I registered to ask a similar question, but ended up getting lucky and finding the answer myself instead.

My problem was that after upgrading to CiviCRM 4, quick search was taking 40-90 seconds to display results on a database with about 85,000 records.

The solution was on the "Settings - Search Preferences" item in the Administration Console. I actually changed a few settings so I'm not sure which was the solution or if it was a combination of them. Here they are:
Automatic wildcard was not set. I set it to No.
Include Email was not set. I set it to No.
Include nickname was set to No. I set it to Yes. (I doubt this one had anything to do with the problem)
Smart group cache timeout was not set. I set it to 5.

Searches are now taking under 2 seconds.

adixon

  • I post frequently
  • ***
  • Posts: 314
  • Karma: 19
    • Blackfly Solutions
Re: Speeding up CiviCRM
October 04, 2012, 12:29:02 pm
Well, for what it's worth, I'd put in a good word for recent versions of CiviCRM being faster than the old ones. Somewhere in the 3.x series there was some great work done.

I run a lot of CiviCRM installs and I don't find CiviCRM to be a drag at all, in general. So if you do have a performance problem, I'd recommend to start not with the question "how do you speed up civicrm", but "why is my particular instance so slow", and even better: why is a specific url or urls on my instance so slow. There are various possibilities, but they all depend on your details, not on the general code base. I think the replies to this posting are all good illustrations of this.


 

awasson

  • I post frequently
  • ***
  • Posts: 230
  • Karma: 7
  • Living in a world of Drupal / CiviCRM
    • My Company: Luna Design
  • CiviCRM version: Latest
  • CMS version: Drupal 6/7/8
  • MySQL version: 5.x
  • PHP version: 5.3.x
Re: Speeding up CiviCRM
August 15, 2013, 10:26:22 am
I realize this is a bit of an old topic but it is a pretty important one. I've found that on all the instances of CiviCRM I've installed. tweaking the search settings is imperative to achieving a useful searching environment.

Just by simply changing the Contact Reference Options so that it only uses the name and email address will shave a massive amount of time from searching.

Andrew
My CiviCRM Extension Workshop: https://github.com/awasson

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Speeding up CiviCRM
August 15, 2013, 01:05:59 pm
Hi,

Tried to wrap the good practices in an extension for the autocomplete search

https://github.com/TechToThePeople/eu.tttp.qlookup

Two guiding principles
1) don't ask for the details of the context, d you best to find the most relevant results
2) put the most relevant results first

X+
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Speeding up CiviCRM

This forum was archived on 2017-11-26.