Connection Optimizations

You may be able to further improve performance by configuring four connection pool settings.

• Validate Atmost Once: Reduces the number of validation requests by a connection. Specify the amount of time (in seconds), after which a connection is validated atmost once. Default value is 0 which means this property is not enabled.

• Associate with Thread: Associates a connection with the thread. When the same thread is in need of a connection, it reuses the connection associated with it. This avoids the overhead of getting a connection from the pool. Values can be either true or false; default is false.

• Lazy Connection Association: Lazily associates connections when an operation is performed on them. They are disassociated when the transaction is completed and a component method ends, which helps reuse of the physical connections. Default value is false.

• Lazy Connection Enlistment: Enable this option to enlist a resource to the transaction only when it is actually used in a method.