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) »
  • General Discussion (please no support requests here!) (Moderator: Michał Mach) »
  • General speed issues
Pages: [1]

Author Topic: General speed issues  (Read 567 times)

tastrax

  • I’m new here
  • *
  • Posts: 9
  • Karma: 0
  • CiviCRM version: 4.5.2
  • CMS version: Wordpress
  • MySQL version: no idea - developers look after that for us
  • PHP version: no idea - developers look after that for us
General speed issues
April 27, 2015, 03:17:03 am
Just a quick question hopefully.

We have recently been using CiviCRM after coming from a custom CMS that was over 10 years old. We have around 20,000 contacts/members, regularly send emails to 50 - 100 people and quarterly to 3000. We are experiencing really slow connections to smart groups (we have about 120 smart groups) and then really slow connections to emailing those members. Is this the norm? Our old system handled this seamlessly on a shared server but CivCRM seems to be struggling to the point we need to consider ditching it altogether (despite it costing us $1,000's to implement it).

Would it be the norm (with the above member numbers) to take 3 minutes to go to Contacts, Manage groups, find the group by a search, select all the contacts and then use the Action of Email Members?

Fabian_SYSTOPIA

  • I post occasionally
  • **
  • Posts: 74
  • Karma: 3
  • CiviCRM version: 4.3.x, 4.4.x
  • CMS version: Drupal 7.x
  • MySQL version: 5.4.10
  • PHP version: 5.4.10
Re: General speed issues
April 27, 2015, 04:23:53 am
Hi Tastrax,

smart groups can be quite demanding for your system. You could see them as saved searches that CiviCRM performs in the background (via a cron job) or "on demand" (e.g. if you want to show contacts in a smart group) in order to keep your groups up to date.

In your case that means CiviCRM has to perform about 120 searches on 20k whenever the cron job runs or if you want to use smart groups and they are not cached.

In order to speed things up, there is a smart group cache - cached groups allow for much faster search results. You can check if the cron job is activated here: yourdomain.com/civicrm/admin/job?reset=1

Two things you could try:

Configure the Cron Job "Rebuild Smart Group Cache" and see if it helps. This can be a bit tricky, as it also depends how cronjobs are configured on your system. I would strongly advise to try out new settings on a non-productive environment.

Try to reduce the number and complexity of smart groups, if possible. Especially try to avoid "nested" smart groups such as "Smart Group A contains all contacts of Smart Group B & C, whereas Smartgroup B contains contacts of Smartgroup D& E...".

Maybe someone could post their experiences on good settings for the cron jobs for a similar scenario?

tastrax

  • I’m new here
  • *
  • Posts: 9
  • Karma: 0
  • CiviCRM version: 4.5.2
  • CMS version: Wordpress
  • MySQL version: no idea - developers look after that for us
  • PHP version: no idea - developers look after that for us
Re: General speed issues
April 27, 2015, 05:56:31 pm
Thanks Fabian - I will check out those settings

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: General speed issues
April 29, 2015, 10:25:16 am
CiviCRM is inherently a resource-intensive package and it's recommended to use a host with experience successfully hosting it. You can find a list here:

https://civicrm.org/providers/hosting

Many users have found that switching to such a host helps with performance issues.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • General Discussion (please no support requests here!) (Moderator: Michał Mach) »
  • General speed issues

This forum was archived on 2017-11-26.