Table securitygroups_records : 6,256,816 rows and 5,7 Gt

SuiteCRM Forum - English Language SuiteCRM General Discussion
1

Tables aow_processed_aow_actions and aow_processed are also huge, over 4 Gt each. They have grown rapidly by one workflow which was set to ‘Repeated run’.

What is the best and safest way to clean thoses tables and remove unnecessary rows?

Thanks in advance.

BR,
PH

2

Hi again,

so is it safe to remove rows from securitygroups_records, aow_prosessed and aow_prosessed_aow_actions tables? E.g. delete all records older than one month?

BR,
Pasi

3

Is there any news on this?