Answers.Body: <p>A variation that might be easier is put whatever you did to test removing the content into a script and run it daily via cron. I'm assuming you did something like</p>
  
  <p>UPDATE civicrm_activity set details='' WHERE (something)</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-09-30T17:38:53.353Z
Answers.LastActivityDate: 2016-09-30T17:38:53.353Z
Answers.UserDisplayName: Demerit
Body: <p>Our DB is larger than we would like. Just two tables, activity and log_activity make up more than 25% of the DB size.</p>
  
  <p>We send secheduled reminders for memberships and to potential new members who have visited our booth at expos. We want an activity that records an email was sent, but we don't need to store the content of the emails in the activity, just the subject is enough. We removed the content of the emails on our staging site and the tables dropped to about 30% of the original size.</p>
  
  <p>At the moment when creating a scheduled reminder there is a tick box for "Record activity for automated email".  Would it be appropriate and feasible to have another tick box to indicate whether or not the content of the email should be stored in the activity?  (Probably for some schedule reminders of, say, payments owing storing the content of the email on each activity would be desirable.</p>
  
  <p>Am I right in thinking this should be tackled via an extension?</p>
  
Tags: <extension><activities><scheduled-reminders>
Title: Would it be feasible to store the fact that a scheduled reminder has been sent, without storing the content of the email?
ThreadText: # Would it be feasible to store the fact that a scheduled reminder has been sent, without storing the content of the email?
  
  (Asked by: username_0 on 2016-09-30)
  
  Our DB is larger than we would like. Just two tables, activity and log\_activity make up more than 25% of the DB size.
  
  We send secheduled reminders for memberships and to potential new members who have visited our booth at expos. We want an activity that records an email was sent, but we don't need to store the content of the emails in the activity, just the subject is enough. We removed the content of the emails on our staging site and the tables dropped to about 30% of the original size.
  
  At the moment when creating a scheduled reminder there is a tick box for "Record activity for automated email". Would it be appropriate and feasible to have another tick box to indicate whether or not the content of the email should be stored in the activity? (Probably for some schedule reminders of, say, payments owing storing the content of the email on each activity would be desirable.
  
  Am I right in thinking this should be tackled via an extension?
  
  **Tags:** extension, activities, scheduled-reminders
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2016-09-30. Score: 1
  
  A variation that might be easier is put whatever you did to test removing the content into a script and run it daily via cron. I'm assuming you did something like
  
  UPDATE civicrm\_activity set details='' WHERE (something)
  
  
  ---
  
  