Tweet
hello,
in our company we do a lot of tecnical processess that generates many... many records ( in millions) in
tables:
bpmn_process
bpmn_flow_node
checkbox on flowchart edit form enable/disable storing peocessess will help a lot in saving DB space.
we've done cleaning by hand, deleting from DB for specific flowcharts and createdAt older than 14 days
delete from bpmn_flow_node where flowchart_id = '[smoe flowcharrt id]' and created_at < NOW() - INTERVAL 14 DAY;
delete from bpmn_process where flowchart_id = '[smoe flowcharrt id]' and created_at < NOW() - INTERVAL 14 DAY;
sure whe can run sh script by cron every day but may but there is no sense to store it if it will be deleted soon
or maybe integer field to specify how long should processess to be stored for every flowchart
default is empty = value from config file
value 0 = don't store
what do You think?
in our company we do a lot of tecnical processess that generates many... many records ( in millions) in
tables:
bpmn_process
bpmn_flow_node
checkbox on flowchart edit form enable/disable storing peocessess will help a lot in saving DB space.
we've done cleaning by hand, deleting from DB for specific flowcharts and createdAt older than 14 days
delete from bpmn_flow_node where flowchart_id = '[smoe flowcharrt id]' and created_at < NOW() - INTERVAL 14 DAY;
delete from bpmn_process where flowchart_id = '[smoe flowcharrt id]' and created_at < NOW() - INTERVAL 14 DAY;
sure whe can run sh script by cron every day but may but there is no sense to store it if it will be deleted soon
or maybe integer field to specify how long should processess to be stored for every flowchart
default is empty = value from config file
value 0 = don't store
what do You think?