REST API slow performance over large data sets in BPM Suite 6
Issue
Couple of REST queries are performing really slow - results are returned in a matter of minutes, sometimes not at all. The same REST queries works fine with small data sets, but when the number of rows in Task and PotentialOwners tables exceed couple of thousands entries, the issues starts to manifest.
This is one of the query which performs very slow:
http://<HOST>:<PORT>/business-central/rest/task/query/?potentialOwner\=<VALUE>\&status\=ready\&status\=inprogress\&status\=reserved
Environment
- Red Hat JBoss BPM Suite
- 6.1.0
- 6.1.1
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.