Chapter 14. Performance Pack
Prev | Part V. Kodo JDO Reference Guide | Next

## Chapter 14. Performance Pack

The Kodo JDO Performance Pack is a suite of features that enhance the speed and functionality of the Kodo runtime. The Performance Pack is included in all Enterprise Edition licenses, or can be purchased separately. Contact sales@solarmetric.com for details.

## 14.1. SQL Batching

In addition to connection pooling and prepared statement caching, Kodo can be configured to employ SQL batching to speed up JDBC updates. By default, SQL batching is enabled for any JDBC driver that supports it. When batching is on, Kodo JDO automatically orders its SQL statements to maximize the size of each batch. This can result in large performance gains for transactions that modify a lot of data.

SQL batching is configured through the system `DBDictionary`, which is controlled by the `kodo.jdbc.DBDictionary` configuration property. The example below shows how to enable and disable SQL batching via the configuration properties file.

Example 14.1. Configuring SQL Batching

The batch limit is the maximum number of statements Kodo will ever batch together. A value of -1 means "no limit" (this is the default for most dictionaries). A value of 0 disables batching.

    kodo.jdbc.DBDictionary: BatchLimit=25

Prev | Up | Next
13.8. Non-relational Database Access | Home | 14.2. Eager Fetching