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 »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Saving a relationship takes a very long time from the CiviCRM interface
Pages: [1]

Author Topic: Saving a relationship takes a very long time from the CiviCRM interface  (Read 480 times)

lolas

  • I post frequently
  • ***
  • Posts: 134
  • Karma: 9
    • Freeform Solutions
  • CiviCRM version: Several
  • CMS version: Drupal
  • MySQL version: 5.1+
  • PHP version: Several
Saving a relationship takes a very long time from the CiviCRM interface
January 01, 2013, 09:24:54 am
I'm having an issue in one implementation where we were considering using permissioned relationships. We noted that it seemed to take a long time to save these relationships. Therefore we are not using permissioned relationships - just plain relationships and we are dealing with permissions in hooks. However, it still sometimes takes a very long time (a couple of minutes or more) to save a relationship from the CiviCRM backend with neither of the two permission checkboxes selected. This is on a dedicated server with 4GB RAM where no performance tuning has been done but everything else is pretty quick including every other CiviCRM function. We have some Drupal hooks that create and search for relationships via the API and these seem to be working quickly.

Does anybody have any suggestions for how to investigate this?
Freeform Solutions provides technology and management consulting, website and database development, and managed internet hosting solutions for not-for-profit organizations (NFPs).

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Saving a relationship takes a very long time from the CiviCRM interface
January 01, 2013, 01:20:50 pm
Log slow queries and see if there is something in there
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

lolas

  • I post frequently
  • ***
  • Posts: 134
  • Karma: 9
    • Freeform Solutions
  • CiviCRM version: Several
  • CMS version: Drupal
  • MySQL version: 5.1+
  • PHP version: Several
Re: Saving a relationship takes a very long time from the CiviCRM interface
January 02, 2013, 08:07:36 am
Thanks. You are right. Start with the basics.
Freeform Solutions provides technology and management consulting, website and database development, and managed internet hosting solutions for not-for-profit organizations (NFPs).

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Saving a relationship takes a very long time from the CiviCRM interface
January 02, 2013, 04:28:01 pm
Do you have smart groups based on relationships? It may be recalculating these? (smart groups based on relationships are a known performance gotcha - hopefully an item to be tackled under the performance MIH)
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Saving a relationship takes a very long time from the CiviCRM interface

This forum was archived on 2017-11-26.