Hi All,
The HistoryService provides the interfaces to interact with historic data. Any process instance, including unfinished, finished and deleted can be retrieved via HistoryService.
Here comes my question:
-
If our system generates more than 100,000 process instances per year, it seems like the history table volume will keep increasing. What kind of action we have to take to optimize it? Maybe something like scheduled archiving? Any advice?
-
There definitely are lots of deleted process instance historic data, we maybe want to clean it every 3 months. Then how can I query all the deleted process instances? It looks like historyService.createHistoricProcessInstanceQuery() does not provide a method to filter it out.
-
If we are doing the database migration someday. If there any way we can migrate the workflow data as well? Backup & restore might not help because the database might be different.
Thanks for any help in advance.