by CM & Sugar

Creating individual workflow processes and define detailed automatization tasks for your CRM. Break out of the standard Sugar workflow frame and extend your CRM with your very own, personal BI. No need of hiring external consultants doing your customizations; stop dealing with compatibility problems and communication issues that come with it. Save money and get done faster! Keep your CRM as it is meant to be, your CRM!

Free 30 day trial
Try it Now

By clicking you consent to share your profile with the developer

#3320 - Workflow aow_processed and aow_actions tables!

Open General Question created by it12 6 years ago

Dear Sirs,

I have discovered recently that CRM database size is 80% large with aow_processed and aow_actions tables and only 20% with the rest. Database is 29GB in size and only because of these 2 tables. Is advanced workflow same way filling up the database as standard CRM workflow, are there any differences?

Thank you very much.

Best Regards,

Slaven.

  1. cm_sugar member avatar

    CM & Sugar Provider Affiliate

    6 years ago

    Hello, since I am not using any aow modules, I cant give you a satisfying answer. However, my plugin does use a logging table for triggered records, which got linked to any defined workflow. It is mandatory to log them, if you have a certain limit defined. For example I provide the feature that you can trigger workflow just one time (eg new record) and never again. Thus I need to store the record somewhere. Further, I do save the logged records, but only once it has been identified to trigger any linked action. Therefore it should produce way lesser overhead than aow modules, where they save all the time any interaction of any SugarCRM record.

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating