Answers.Body: <p>This PR resolved this <a href="https://github.com/progressivetech/net.ourpowerbase.sumfields/pull/62" rel="nofollow noreferrer">https://github.com/progressivetech/net.ourpowerbase.sumfields/pull/62</a></p>
  <p>with an <strong>Exclude Summary Fields from logging?</strong> feature.</p>
  <blockquote>
  <p>When advanced logging is turned on, you can exclude Summary Fields
  from being logged to increase performance and reduce clutter.</p>
  </blockquote>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-04-22T17:22:06.693Z
Answers.LastActivityDate: 2021-04-22T17:22:06.693Z
Answers.UserDisplayName: Andy Burns
Body: <p>On some but not all records, we see over 2K change log entries.</p>
  <p><a href="https://i.sstatic.net/Nhy9k.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/Nhy9k.png" alt="enter image description here" /></a></p>
  <p>On this record, the change log started and ran continuously from 11-26-19 to 1-20-2020</p>
  <p><a href="https://i.sstatic.net/8FPTH.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/8FPTH.png" alt="enter image description here" /></a></p>
  <p>Another instance I had imported to the preferred communication field and the import ran for ~20 minutes. The change log was continually getting written to for the entire import process.</p>
  <p>For now, I have turned off detailed logging. We are using a separate db for it. Thoughts on what is going on here?</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-01-28T19:38:03.277Z
Comments.Text: Do you have cron scripts that do something related every 15 min? Something that maybe only touches some contacts?
Comments.UserDisplayName: Demerit
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-01-28T19:58:28.153Z
Comments.Text: The civicrm_log doesn't show these numerous changes.
Comments.UserDisplayName: Andy Burns
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-01-28T20:00:37.843Z
Comments.Text: It could be something like SQL statements or calls that use something like `$dao->save();` instead of the api, so it might bypass civicrm_log but not the triggers. The report you've screenshot'd will show what the changes are if you click on them - do they give any clues?
Comments.UserDisplayName: Demerit
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-01-29T17:24:13.083Z
Comments.Text: I've seen something similar which was the summary fields extension running every hour and so almost every contact had an update logged every hour.  So, I changed the frequency to daily.
Comments.UserDisplayName: Andy Clark
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-01-29T17:27:20.837Z
Comments.Text: I do have the summary fields job running hourly. I have switched to daily.
Comments.UserDisplayName: Andy Burns
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-01-29T18:53:31.410Z
Comments.Text: Let me know if the logs reduce and I'll add it as an answer
Comments.UserDisplayName: Andy Clark
Tags: <logging>
Title: Detailed logging running continually
ThreadText: # Detailed logging running continually
  
  (Asked by: username_0 on 2020-01-28)
  
  On some but not all records, we see over 2K change log entries.
  
  [![enter image description here](https://i.sstatic.net/Nhy9k.png)](https://i.sstatic.net/Nhy9k.png)
  
  On this record, the change log started and ran continuously from 11-26-19 to 1-20-2020
  
  [![enter image description here](https://i.sstatic.net/8FPTH.png)](https://i.sstatic.net/8FPTH.png)
  
  Another instance I had imported to the preferred communication field and the import ran for ~20 minutes. The change log was continually getting written to for the entire import process.
  
  For now, I have turned off detailed logging. We are using a separate db for it. Thoughts on what is going on here?
  
  **Tags:** logging
  
  > **Comments:**
  > **username_1**: Do you have cron scripts that do something related every 15 min? Something that maybe only touches some contacts?  
  > **username_0**: The civicrm_log doesn't show these numerous changes.  
  > **username_1**: It could be something like SQL statements or calls that use something like `$dao->save();` instead of the api, so it might bypass civicrm_log but not the triggers. The report you've screenshot'd will show what the changes are if you click on them - do they give any clues?  
  > **username_2**: I've seen something similar which was the summary fields extension running every hour and so almost every contact had an update logged every hour.  So, I changed the frequency to daily.  
  > **username_0**: I do have the summary fields job running hourly. I have switched to daily.  
  > **username_2**: Let me know if the logs reduce and I'll add it as an answer  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2021-04-22. Score: 1 | Accepted answer
  
  This PR resolved this <https://github.com/progressivetech/net.ourpowerbase.sumfields/pull/62>
  
  with an **Exclude Summary Fields from logging?** feature.
  
  > When advanced logging is turned on, you can exclude Summary Fields
  > from being logged to increase performance and reduce clutter.
  
  
  ---
  
  