Answers.Body: <p>I think this would be a relatively simple fix. I'd suggest you file an issue for this and, ideally, provide a patch...</p>
  
  <p>...actually in fiddling around with this I just wrote a patch that fixes it. Try this:</p>
  
  <p><a href="https://github.com/civicrm/civicrm-core/pull/6283" rel="nofollow">#6283 Don't force-refresh the changelog tab to avoid performance overhead</a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-07-22T11:08:17.497Z
Answers.Text: Thanks Coleman! Ingenious, works for me, tested on the above 4.6.4 site. Really appreciate this prompt and extremely helpful response. Thanks again.
Answers.UserDisplayName: davejenx
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-07-21T20:10:37.327Z
Answers.LastActivityDate: 2015-07-27T00:39:29.553Z
Answers.LastEditDate: 2015-07-27T00:39:29.553Z
Answers.UserDisplayName: Coleman
Body: <p>On the contact summary page in CiviCRM 4.6.4 with advanced logging enabled, after doing an inline edit of address or phone, an AJAX query is triggered for a logging report URL:</p>
  
  <p>/civicrm/report/instance/87?reset=1&amp;force=1&amp;section=2&amp;altered_contact_id_op=eq&amp;altered_contact_id_value=59625&amp;cid=59625&amp;qfKey=blah&amp;crmPID=2&amp;snippet=json</p>
  
  <p>Report instance 87 is a reserved instance of Contact Logging Report (Summary) with report_id logging/contact/summary .</p>
  
  <p>This is a problem on a site with a large number of log entries: in this case, 4.8 million in log_civicrm_activity_contact. The logging queries take many minutes to complete. So a simple inline edit triggers heavyweight queries that slow down the database.</p>
  
  <p>I'm guessing this is done in order to update the count on the Change Log tab heading. In Civi 4.4, if advanced logging is enabled then the Change Log tab heading does not show a count. This is preferable. Was the count added as a result of a feature request? Can it be disabled?</p>
  
Tags: <logs><performance>
Title: Can we disable resource-intensive logging queries triggered by inline edit?
ThreadText: # Can we disable resource-intensive logging queries triggered by inline edit?
  
  (Asked by: username_0 on 2015-07-21)
  
  On the contact summary page in CiviCRM 4.6.4 with advanced logging enabled, after doing an inline edit of address or phone, an AJAX query is triggered for a logging report URL:
  
  /civicrm/report/instance/87?reset=1&force=1&section=2&altered\_contact\_id\_op=eq&altered\_contact\_id\_value=59625&cid=59625&qfKey=blah&crmPID=2&snippet=json
  
  Report instance 87 is a reserved instance of Contact Logging Report (Summary) with report\_id logging/contact/summary .
  
  This is a problem on a site with a large number of log entries: in this case, 4.8 million in log\_civicrm\_activity\_contact. The logging queries take many minutes to complete. So a simple inline edit triggers heavyweight queries that slow down the database.
  
  I'm guessing this is done in order to update the count on the Change Log tab heading. In Civi 4.4, if advanced logging is enabled then the Change Log tab heading does not show a count. This is preferable. Was the count added as a result of a feature request? Can it be disabled?
  
  **Tags:** logs, performance
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2015-07-21. Score: 3 | Accepted answer
  
  I think this would be a relatively simple fix. I'd suggest you file an issue for this and, ideally, provide a patch...
  
  ...actually in fiddling around with this I just wrote a patch that fixes it. Try this:
  
  [#6283 Don't force-refresh the changelog tab to avoid performance overhead](https://github.com/civicrm/civicrm-core/pull/6283)
  
  > **Comments:**
  > **username_0**: Thanks username_1! Ingenious, works for me, tested on the above 4.6.4 site. Really appreciate this prompt and extremely helpful response. Thanks again.  
  
  ---
  
  