CiviCRM Community Forums (archive)

Hey,

I have a problem. At a large installation of CiviCRM we have a problem that people are being signed up as a participant for an event. But when more people are doing that the mysql server gets slow and ends in a transaction lock.

Investigating the problem I discover that the smart groups are being rebuild which is in this installation something which causes many headaches. But I am wondering why on earth the the Group Contact Cahce is empties as soon as someone is registered as participant.

File CRM/Event/BAO/Participant.php

class CRM_Event_BAO_Participant extends CRM_Event_DAO_Participant {
    ...
   static function &add(&$params) {
      ...
      // reset the group contact cache for this group
      CRM_Contact_BAO_GroupContactCache::remove();

      if (CRM_Utils_Array::value('id', $params)) {
        CRM_Utils_Hook::post('edit', 'Participant', $participantBAO->id, $participantBAO);
      }
      else {
        CRM_Utils_Hook::post('create', 'Participant', $participantBAO->id, $participantBAO);
      }
    return $participantBAO;
  }
...

See also this line on github: https://github.com/civicrm/civicrm-core/blame/master/CRM/Event/BAO/Participant.php#L146

Is there a reason to empty the group contact cache?