Our act_ru_job accumulated 1.7million entries and each job acquisition query now takes about 18 minutes. Aside from increasing max-jobs-per-acquisition and upgrading postgres server, are there any other ways to reduce the time spent on each job acquisition? We are not using jobExecutorAcquireByPriority, jobExecutorPreferTimerJobs, or jobExecutorAcquireByDueDate (should we)?
Thanks for your help.
<camunda-bpm-spring-boot-starter.version>7.16.0</camunda-bpm-spring-boot-starter.version>
<camunda-bpm-spring-boot-starter-external-task-embedded-client.version>0.2.0</camunda-bpm-spring-boot-starter-external-task-embedded-client.version>
<camunda-bpm-spring-boot-starter-test.version>2.2.0</camunda-bpm-spring-boot-starter-test.version>
<camunda-bpm-assert.version>8.0.0</camunda-bpm-assert.version>