Connection pooling is a technique for sharing server resources among end users of a requesting client application. It enables multiple end users to share a cached set of connection objects that provides access to Vantage. Connection pooling improves performance by eliminating the overhead associated with establishing a new connection to Vantage for each request submitted by a client application end user.
Because it is not possible to reset a connection to Vantage, you should avoid changing any of the following session parameters during a pooled session (including trusted sessions), because these parameter changes are inherited by the next user of the pooled connection.
- Character set
- Collation
- Database
- Dateform
- Default Date Format
- Time zone
- Transaction Isolation Level