Is there any best practice for outsourcing data for performance reasons? Is it recommended to wrap Camunda with another service that duplicates the main table’s data by persisting API calls? It absolutely could help in the performance of reports. But do all, for example, tasks/jobs/variables necessarily created by APIs? Or it may lead to inconsistency of data?
Below link maybe of help to you
Pushing Events mechanism might be the one you are looking for. You can find more in below section.