■
“Timeout Settings” on page 78
■
“Isolation Level Settings” on page 79
■
“Connection Validation Settings” on page 79
Pool Size Settings
The following settings control the size of the connection pool:
Initial and
Mimimum Pool
Size
Size of the pool when created, and its minimum allowable size.
Maximum Pool
Size
Upper limit of size of the pool.
Pool Resize
Quantity
Number of connections to be removed when the idle timeout expires. Connections that have idled for
longer than the timeout are candidates for removal. When the pool size reaches the initial and minimum
pool size, removal of connections stops.
The following table summarizes pros and cons to consider when sizing connection pools.
TABLE3–4 ConnectionPoolSizing
Connectionpool Pros Cons
Small Connection pool Faster accesson the connection table. May nothave enough connections to
satisfy requests.
Requests may spendmore time in the
queue.
Large Connection pool Moreconnections to fulll requests.
Requests will spendless (or no) time in the
queue
Slower access onthe connection table.
Timeout Settings
There are two timeout settings:
■
Max Wait Time: Amount of time the caller (the code requesting a connection) will wait
before getting a connection timeout. The default is 60 seconds. A value of zero forces caller
to wait indenitely.
To improve performance set Max Wait Time to zero (0). This essentially blocks the caller
thread until a connection becomes available. Also, this allows the server to alleviate the task
of tracking the elapsed wait time for each request and increases performance.
Initialand MimimumPoolSize
SunGlassFishEnterpriseServer2.1PerformanceTuningGuide • January200978