Camunda API queries are too slow

Camunda 7 Topics Discussion & Questions
1

We are using Camunda Rest API to query historic process instances, task instances and variable instances.

We are facing slowness in rest API’s.

Is there any index created for those tables for querying purpose ?
If we create index for those tables will it improve performance?

2

Hi @aravindhrs,

a slow query performance to retrieve historical data could have multiple reasons, e.g.:

  • huge amounts of data => getting rid of outdated data via History Cleanup could solve this problem
  • missing indices => could you please validate if you have set all indices? You can find these in the SQL scripts of the distribution

Could you please check your server log if you are facing any exceptions?

Cheers,
Tassilo

3

We are not facing any exceptions in server. But queries took long time to respond.

I was using Camunda Rest API, and when i start the microservice, tables and indexes are created automatically by the scripts. When i look into SQL client, i can see indexes for those tables.

image

image
image977×436 29.4 KB

How to run history cleanup periodically as batch job without any manual intervention to history cleanup?

4

@tasso94 how can we achieve that? we are using rest api’s to communicate to camunda server. Is that possible to configure periodic jobs to execute asynchronously in background?