What is the recommended prepared statement cache size for the application?

An administrator has deployed an application that uses 30 unique SQL statements with a maximum data source connection pool size of 10.

What is the recommended prepared statement cache size for the application?
A . 10
B . 30
C . 40
D . 300

View Answer

Answer: B

Explanation:

To determine the highest value for your cache size to avoid any cache discards, add the number of uniquely prepared statements and callable statements, as determined by the SQL string, concurrency, and the scroll type, for each application that uses this data source on a particular server. This value is the maximum number of possible statements that can be cached on a given connection over the life of the server. Setting the cache size to this value means that you never have cache discards. In general, configure a larger cache for applications with a greater number of statements.