SugarChimp

Hi Heidi,

the sugarchimpactivity_leads table is at 4.4 GB (8.8 M rows) and sugarchimpactivity 11.7 GB (8.8 M Rows). The additional data is on our test instance so I'm sure that's ok to delete : sugarchimpactivity_leads 5.2 GB / sugarchimpactivity_contacts 194.3 MB

Thanks!

Perfect, thanks. Looks like these are the activities tables and are totally okay to truncate. They're responsible for holding the campaign activity we sync from Mailchimp to Sugar and display within the Mailchimp Activities subpanel. Over time, these tables to get larger as we sync those activities over. If you're okay losing all the activities, they can be fully emptied. If you want to keep more recent activities, you can have Sugar truncate rows that are older than a certain timeframe, such as 30 days.

To prevent the tables from getting this large in the future, you can set SugarChimp to automatically delete synced activities beyond a certain number of days. Since a lot of customers don't regularly review campaigns sent beyond 90 or 180 days, for example, those activities can be deleted from Sugar. To update that setting, you can follow the step below.

1. From within SugarChimp's Health Status page, right click anywhere on the page and select Inspect.
2. Click the Console tab
3. Copy/paste the following into the console and press Enter: SUGAR.App.api.call('get',SUGAR.App.api.buildURL('SugarChimp/setting/remove_activities_after_days/90'),{},{});

Let me know if you have any other questions!

Best, Heidi

Thanks!