IBM BPM, V8.0.1, All platforms > Tuning > Advanced tuning > Business Process Choreographer tuning

Tuning task list and process list queries

Task list and process list queries in Business Process Choreographer applications are made using the standard query API ( query() and queryAll() APIs, and related REST and web services interfaces), and the query table API ( queryEntities() and queryRows() APIs).

All task list and process list queries result in SQL queries against the Business Process Choreographer database. These SQL queries might need special tuning to provide optimal response times:

• Up-to-date database statistics are key for good SQL query response times.

• Databases offer tools to tune SQL queries. In most cases, additional indexes are very helpful. For DB2 for z/OS , the Optimization Service Center for DB2 for z/OS and DB2 Optimization Expert for z/OS can be used to help define and design indexes suitable for a particular workload. See http://www-01.ibm.com/software/data/db2imstools/db2tools/accessories-suite/.

Business Process Choreographer tuning

Related tasks:
Optimize task and process queries