Thread Details
  • State Not Answered
  • Replies 6 replies
  • Subscribers 350 subscribers
  • Views 432 views
  • Users 0 members are here
Forum Actions
Related

Clean audit tables?

Jeff Bickart

We have been using Sugar for more than 6 years. We have audit log records that go back to the start of our use of Sugar. The Archive Data tool does not have the ability to archive audit tables. What is the best practice to remove older data from these tables?

Parents
  • 0

    I raised a case with support and they trimmed the pmse_bpm table for us (sell, cloud, 14.0 back then, now 14.2).
    Everything older than a month.

    That seemed to have had a great effect in reducing the DB storage by  3.7GB...!

    I also noticed that when I view the Process List (/#pmse_Inbox/layout/casesList) it's lightning fast... previously I would open it, go and do something else for a bit, then come back to it. So this is a nice improvement too.

    This was in reply to my question/case:

    There is no way via the UI to delete data from a pmse_bpm table. This is on purpose as the data within those tables control moving processes in your instance and deleting something incorrectly can result in lots of problems. The size of your pmse_bpm_flow table is quite typical, but I'd be happy to trim it for you to reduce size if that's okay with you.

Reply
  • 0

    I raised a case with support and they trimmed the pmse_bpm table for us (sell, cloud, 14.0 back then, now 14.2).
    Everything older than a month.

    That seemed to have had a great effect in reducing the DB storage by  3.7GB...!

    I also noticed that when I view the Process List (/#pmse_Inbox/layout/casesList) it's lightning fast... previously I would open it, go and do something else for a bit, then come back to it. So this is a nice improvement too.

    This was in reply to my question/case:

    There is no way via the UI to delete data from a pmse_bpm table. This is on purpose as the data within those tables control moving processes in your instance and deleting something incorrectly can result in lots of problems. The size of your pmse_bpm_flow table is quite typical, but I'd be happy to trim it for you to reduce size if that's okay with you.

Children
No Data