Java DataBase Connectivity data source properties
The settings used to configure the Java™ DataBase Connectivity (JDBC) data source properties were chosen to maximize performance.
Figure 1 displays
the settings for the JDBC data source properties. These are the selected
settings:
- A statement cache size of 60 statements was selected because the
workload produces approximately 60 unique SQL statements that are
then stored as precompiled SQL objects.
Caching these statements improves performance because each cached statement can then be run multiple times without the cost of additional statement preparation. Increasing the cache size to be greater than the number of needed statements is related to higher memory use, which is probably not needed. Too small a cache size causes cached statements to be discarded, and these statements might have to be recreated in the future.
- The setting to enables JMS one-phase optimization support allows JMS to obtain optimized connections from the data source. The workload uses message queues for access to the database; therefore this setting was enabled.
