Answers.Body: <p>Do you have the CiviMember Roles Sync module enabled? The code in this is very similar to the other 'role sync' modules and is currently quite slow. There is an open issue about it here: <a href="https://issues.civicrm.org/jira/browse/CRM-14770" rel="nofollow">https://issues.civicrm.org/jira/browse/CRM-14770</a></p>
  
  <p>Otherwise you could try putting markers in your code at various points to see where the slow-down is happening. Or use a PHP profiling tool.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-20T17:08:25.790Z
Answers.Text: We do have roles sync enabled.
Answers.UserDisplayName: Rob Malerman
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-21T10:05:23.857Z
Answers.Text: Try disabling it - see if that speeds things up - that should help narrow down the issue.
Answers.UserDisplayName: John
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-19T15:00:06.933Z
Answers.LastActivityDate: 2015-05-19T15:00:06.933Z
Answers.UserDisplayName: John
Answers.Body: <p>If the system is that slow perhaps there is a slow mysql query &amp; if you do a show processlist while it is happening you will spot it. My best guess would be a slow de-dupe rule is kicking in.</p>
  
  <p>Be wary about including things with many matches in your dedupe rule - e.g. a city match will have many many pairings who match &amp; will create load. Obviously an email mail is at the opposite end.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-20T10:52:13.413Z
Answers.LastActivityDate: 2015-05-20T10:52:13.413Z
Answers.UserDisplayName: eileen
Body: <p>Civi 4.4.3
  Drupal 7</p>
  
  <p>When creating a new user account by signing up someone for a membership in CiviMember, the system appears to the user to hang.  The processing time is around 80 seconds while the civi account is created, matching drupal account created, card is processed, and other database stuff we are doing to set tags and the like.</p>
  
  <p>Can anyone point me in the direction of any tips or tricks to optimize the process?</p>
  
  <p>Thanks!</p>
  
Tags: <drupal><civimember>
Title: System slow on new account creation
ThreadText: # System slow on new account creation
  
  (Asked by: username_0 on 2015-05-19)
  
  Civi 4.4.3
  Drupal 7
  
  When creating a new user account by signing up someone for a membership in CiviMember, the system appears to the user to hang. The processing time is around 80 seconds while the civi account is created, matching drupal account created, card is processed, and other database stuff we are doing to set tags and the like.
  
  Can anyone point me in the direction of any tips or tricks to optimize the process?
  
  Thanks!
  
  **Tags:** drupal, civimember
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2015-05-19. Score: 1
  
  Do you have the CiviMember Roles Sync module enabled? The code in this is very similar to the other 'role sync' modules and is currently quite slow. There is an open issue about it here: <https://issues.civicrm.org/jira/browse/CRM-14770>
  
  Otherwise you could try putting markers in your code at various points to see where the slow-down is happening. Or use a PHP profiling tool.
  
  > **Comments:**
  > **username_0**: We do have roles sync enabled.  
  > **username_1**: Try disabling it - see if that speeds things up - that should help narrow down the issue.  
  
  ---
  
  ### Answer by username_2 on 2015-05-20. Score: 1
  
  If the system is that slow perhaps there is a slow mysql query & if you do a show processlist while it is happening you will spot it. My best guess would be a slow de-dupe rule is kicking in.
  
  Be wary about including things with many matches in your dedupe rule - e.g. a city match will have many many pairings who match & will create load. Obviously an email mail is at the opposite end.
  
  
  ---
  
  