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 »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Related contact search VERY slow after upgrade to 4.1.5
Pages: [1]

Author Topic: Related contact search VERY slow after upgrade to 4.1.5  (Read 444 times)

jimurl

  • I post occasionally
  • **
  • Posts: 70
  • Karma: 0
  • CiviCRM version: 3.4.6
  • CMS version: drupal 6.22
  • MySQL version: 5+
  • PHP version: 5+
Related contact search VERY slow after upgrade to 4.1.5
August 07, 2012, 09:35:19 am
I recently upgraded 3.4.6 --> 4.1.5, and now any time we do a 'related contact search', it takes on the order of 10 - 15 minutes to complete the search. There are about 600 primary contacts and around 1000 related contacts ( siblings ), so its not a matter of a huge database. CPanel's process manager indicates that the mysqld process is using most of the memory, but not very much CPU. Applying an Action to the resulting list is also slow.

It seems many improvements were made to the related contact searches- such as they can now be reliably used in Smart groups - but my client will expect better performance.

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Related contact search VERY slow after upgrade to 4.1.5
August 11, 2012, 01:25:09 pm
How many contacts are in your DB total? 1600? If so, then a 10 minute query is bizarre. Can you ask your host or sys admin to look at the query in question and see if your MySQL can be optimized a bit?
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) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Related contact search VERY slow after upgrade to 4.1.5

This forum was archived on 2017-11-26.