Concepts
Optimize has six components or activities that access the Optimize database component sets:
analysis.engine Analytic Engine
process.history Analytic Engine
process.model Analytic Engine
process.work Analytic Engine
common.directory Analytic Engine
A typical Optimize configuration of database connection pools involves four connections:
analysis.engine Analytic Engine through a pool to the Analysis database component set
process.history Analytic Engine and process.work Analytic Engine through a single pool to the Process Tracker database component set
process.model Analytic Engine through a pool to the Process Audit Log database component set
common.directory Analytic Engine through a pool to the
My webMethods Server database component set
See the following figure.
Figure 10. Connecting Optimize database activities to Optimize database component sets: typical configuration
In high-volume situations, you may be able to improve performance by assigning separate database connection pools to:
The process.history Analytic Engine and process.work Analytic Engine
Optimize database activities; both connect to the Process Tracker database component set.
The analysis.engine Analytic Engine
Optimize database activities; connects to the Analysis database component set.
See the following figure.
Figure 11. Connecting Optimize database activities to Optimize database component sets: high-volume configuration
Note:
You must define a minimum of one database connection pool per database schema. In an Optimize configuration with four database schemas as shown in the figures above, you must define a minimum of four database connection pools.
