How to deal with the large historical data of camunda database?
Hi,
In most cases you need to decide;
What is the purpose of the historical data?
How long is it useful for each purpose?
Typically historical information is useful for audit, non-repudiation and analytic purposes. In addition, there may be legislative compliance requirements, eg transaction history must be stored for n years…
A common pattern is to use a moving window of history in the engine itself and archive history in an external storage system…
Two concepts you should research are;
Camunda Optimize - which can extract history data for analytics etc…
History Cleanup - set a time to live (TTL) to enable a moving window of history storage…
regards
Rob
1 Like