Overview

Benchmarking has identified that the same database query is often performed numerous times during one transaction in an IBM Cúram Social Program Management application. This is costly in performance terms and to counteract this a transaction SQL query cache is now available in the Server Development Environment (SDEJ). This cache, when enabled, operates at the data access layer and endures for the lifetime of any one transaction. The cache stores the results of any SELECT SQL queries for the duration of the transaction in which the operation was invoked. Subsequent calls in the same transaction will retrieve the required results from the SQL query cache and will not read the results from the database.