Hi out there,
we are already using Camunda for quite a long time, and now we had a look to Optimze.
I am just wondering whether Optimze collects ALL data of the history tables, so it is save to delete all die History Tables (or use the Cleanup Process) without loosing any information?
(One of the reasons to use Camunda was that we perhaps wants to analyse data later, but now we have millions of rows and performance get down. It would be nice if REALLY ALL information go to Optimize / ElasticSearch, so it is save to delete all data in relational databese…)
The new version 2.1.0 of Optimize will be released at the end of the month. With this version you don’t have to worry about deleting data in the engine anymore. So the answer is yes (with some limitations: please refer to my next post)
As you described it, you can use Optimize store all the data and perform the analysis later. You could also have a look at the blog post of the 2.1.0-alpha1 release, where your scenario is described as well.
One important additional remark to my post from before that might be very important for you: Optimize only imports the data that it needs for its analysis. There will be data in the engine that is lost, after you delete it even if Optimize has done the import of the data. Examples would be:
everything about Cases or Decisions
user opertions log
history about tasks
external task log
Since we don’t import it for now. Just that you are aware of that.