REST API slow performance over large data sets in BPM Suite 6

Solution Unverified - Updated -

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.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content