database performance arch_flownode_instance mysql

Database performance issue with MySQL

We are seeing slow query times in our MySQL database backend for Bonita. There is a query that selects data from the arch_flownode_instance table. This table contains about 500,000 records and the query is taking over 2 minutes to execute.

Bonita version: 6.3.7 Community
Bonita & MySQL deployed on Windows Server

The customer is seeing approximately 1,500 - 2,000 cases per day.