Details about this thread
  • State Not Answered
  • +2 person also asked this people also asked this
  • Replies 8 replies
  • Subscribers 307 subscribers
  • Views 1669 views
  • Users 0 members are here
Related content from around SugarClub

How do we reduce storage cost and improve performance by cleaning BPM tables?

Enrico Simonetti

Hello there,

I am working with a Sugar Cloud customer on version 13.0 and they are asking what is the official way to cleanup all BPM SQL tables for old/orphan records.

They already have a cleanup process for the pmse_inbox SQL table through the application tool.

How can we efficiently, effectively and safely clean up SQL tables such as pmse_inbox, pmse_bpm_flow and pmse_bpm_form_action, on an ongoing basis, and also once-off?

Only on the SQL table pmse_bpm_form_action, the customer has about 3M records.

Are there existing best practices, or knowledge bases or tutorials on how to achieve this performance and cost-saving exercise correctly?

We also would like to not have this timeout the schedulers and therefore fail mid-way, especially for the initial cleanups.

Thank you for your help!

Parents Reply Children
  • 0 in reply to Bud Hartley

    That helps if you can hard delete the records.

    The archiver has two options: move to an archive table (does nothing for DB size) or hard delete.

    It would be great if there was an option to archive to an off-site database so that customers had the option to have a data warehouse of older information off of their main Sugar DB.

    Of course this is less of an issue for those of us On-Site since disk space can be more easily managed when you have full control of the database.

    Francesca

  • 0 in reply to Bud Hartley

    Thank you  ,

    I am not sure if it is the specific system I am looking at, or if you have something special on yours, but the only pmse_ table we see is pmse_Inbox.

    See here:

    I was also looking at the actual conditions to delete all related tables that are no longer of interest, as we would not want to inadvertently delete information of in-flight long-running processes...

    --

    Enrico Simonetti

    Sugar veteran (from 2007)

    www.naonis.tech


    Feel free to reach out for consulting regarding:

    • API Integration and Automation Services
    • Sugar Architecture
    • Sugar Performance Optimisation
    • Sugar Consulting, Best Practices and Technical Training
    • AWS and Sugar Technical Help
    • CTO-as-a-service
    • Solutions-as-a-service
    • and more!

    All active SugarCRM certifications

    Actively working remotely with customers based in APAC and in the United States