posted last year in Dev Platform category by Dongsun Choi There
are various techniques to improve the performance of your Java
application. In this article I will talk about Statement Pooling
Configuration and its effect on Garbage Collection process.
Statement Pooling allows to improve the performance of an
application by caching SQL statements that are used repeatedly.
Such caching mechanism allows to prepare frequently used
statements only once and reuse them multiple times, thus
reducing the overall number of times the database server has to
parse, plan, and optimize these queries. A well-configured
number of statements (maxStatements) to be cached can be as good
as tuning the Garbage Collection. Now let's see how Statement
Pooling can affect the Garbage Collection. Why Check the Number
of Statement in the Pool? Often the size of the JDBC statement
pool is set to the default value. Using the default value, of
course does not usually lead to any special issue. But a well-
configured maxStatements value can