Answers.Body: <p>You may be running into performance issues if you have groups in your Search Builder queries.  See <a href="https://issues.civicrm.org/jira/browse/CRM-16483" rel="nofollow">CRM-16483</a>.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-01-12T15:48:38.077Z
Answers.Text: I'm not sure that's what I'm running into, but I think it's likely.  Thanks for the point in right direction.
Answers.UserDisplayName: DaveBagler
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-01-12T00:52:46.563Z
Answers.LastActivityDate: 2016-01-12T00:52:46.563Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.Body: <p>Do you have the problem with the search builder interface that is too slow or after you search to get the result?</p>
  
  <p>How is the advanced search behaving?</p>
  
  <p>The problem is that it's hard to find what the root cause of the problem, as it's likely dependent of your configuration and how you are using civicrm.</p>
  
  <p>One thing you can do is log the slow queries (it's a configuration option in mysql) that takes more than a second. It's not going to solve the problem, but at least might help you to identify the problem </p>
  
  <p>And a wild guess: do you have smart groups? 
  These can have a massive impact on performance. ACL might be another reason that it's slow.</p>
  
  <p>EDIT: more suggestions now that you confirmed smart groups</p>
  
  <p>You might want to cache the smart groups for a longer period of time (say 2 hours)
  Administer > Customize Data and Screens > Search Preferences </p>
  
  <p>and enable the cronjob to re-build the smart groups cache every hour</p>
  
  <p>As for the general speed, it's likely that you need more resources to run civicrm 4.6 compare to 4.4, if your server was already borderline too weak to handle 4.4, the new features introduced by 4.6 might be the extra nudge needed to make it trip over. It might be worthwhile investing a bit more on your hosting.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-01-12T15:46:15.783Z
Answers.Text: The interface is fine (just as bad as it was in 4.4) it's that it times out before returning results. Occasionally when only searing for contacts who are in a smart group.
  
  I realize that smart groups are slow, but with the same configuration it was working in 4.4, that's why I'm wondering if something changed between 4.4 and 4.6.10 that would impact the performance of Search Builder.
Answers.UserDisplayName: DaveBagler
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-01-12T16:19:44.510Z
Answers.Text: Advanced search is also far slower than it used to be.
Answers.UserDisplayName: DaveBagler
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-01-12T09:43:16.043Z
Answers.LastActivityDate: 2016-01-12T16:35:06.077Z
Answers.LastEditDate: 2016-01-12T16:35:06.077Z
Answers.UserDisplayName: Xavier
Body: <p>I recently upgraded from 4.4 to 4.6 using Drupal 7 and since then I have had some major performance problems (Search Builder responds to everything with a Timeout now.) Even simple queries for users in a group will often timeout.  Before the upgrade I had no problems. Has anyone else run into performance problems with 4.6.10? Any suggestions?</p>
  
  <p><strong>Updates</strong></p>
  
  <ul>
  <li>Searches were fine before the update</li>
  <li>I am using smart groups</li>
  </ul>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-01-11T20:45:53.623Z
Comments.Text: During or since the upgrade, have you deleted the contents of your temp_c folder and cleared cache for CiviCRM?
Comments.UserDisplayName: Allen Hutchison
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-01-11T21:03:12.260Z
Comments.Text: Yeah before I upgraded, and again since I've upgraded.
Comments.UserDisplayName: DaveBagler
Tags: <performance>
Title: Major Performance Hit After 4.6 Upgrade
ThreadText: # Major Performance Hit After 4.6 Upgrade
  
  (Asked by: username_0 on 2016-01-11)
  
  I recently upgraded from 4.4 to 4.6 using Drupal 7 and since then I have had some major performance problems (Search Builder responds to everything with a Timeout now.) Even simple queries for users in a group will often timeout. Before the upgrade I had no problems. Has anyone else run into performance problems with 4.6.10? Any suggestions?
  
  **Updates**
  
  * Searches were fine before the update
  * I am using smart groups
  
  **Tags:** performance
  
  > **Comments:**
  > **username_1**: During or since the upgrade, have you deleted the contents of your temp_c folder and cleared cache for CiviCRM?  
  > **username_0**: Yeah before I upgraded, and again since I've upgraded.  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_2 on 2016-01-12. Score: 2
  
  You may be running into performance issues if you have groups in your Search Builder queries. See [CRM-16483](https://issues.civicrm.org/jira/browse/CRM-16483).
  
  > **Comments:**
  > **username_0**: I'm not sure that's what I'm running into, but I think it's likely.  Thanks for the point in right direction.  
  
  ---
  
  ### Answer by username_3 on 2016-01-12. Score: 1
  
  Do you have the problem with the search builder interface that is too slow or after you search to get the result?
  
  How is the advanced search behaving?
  
  The problem is that it's hard to find what the root cause of the problem, as it's likely dependent of your configuration and how you are using civicrm.
  
  One thing you can do is log the slow queries (it's a configuration option in mysql) that takes more than a second. It's not going to solve the problem, but at least might help you to identify the problem
  
  And a wild guess: do you have smart groups?
  These can have a massive impact on performance. ACL might be another reason that it's slow.
  
  EDIT: more suggestions now that you confirmed smart groups
  
  You might want to cache the smart groups for a longer period of time (say 2 hours)
  Administer > Customize Data and Screens > Search Preferences
  
  and enable the cronjob to re-build the smart groups cache every hour
  
  As for the general speed, it's likely that you need more resources to run civicrm 4.6 compare to 4.4, if your server was already borderline too weak to handle 4.4, the new features introduced by 4.6 might be the extra nudge needed to make it trip over. It might be worthwhile investing a bit more on your hosting.
  
  > **Comments:**
  > **username_0**: The interface is fine (just as bad as it was in 4.4) it's that it times out before returning results. Occasionally when only searing for contacts who are in a smart group.  I realize that smart groups are slow, but with the same configuration it was working in 4.4, that's why I'm wondering if something changed between 4.4 and 4.6.10 that would impact the performance of Search Builder.  
  > **username_0**: Advanced search is also far slower than it used to be.  
  
  ---
  
  