How to deal with the large historical data of camunda database?
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…