Fine Tuning Performance Using Connection Pools
A connection pool is a cache of database connections for reuse when future requests to the database need them. These open and available connections make sending requests to the database faster. The connection pool can reduce or eliminate the need to open a new connection for each request.
To fine tune connection pool performance
1. Log into Studio as the admin user.
2. From the Administration menu, choose Configuration.
3. In the tree pane, navigate to Configuration > Data Sources > Common to Multiple Source Types.
4. You can manipulate the following parameters to tune connection pool performance. You might need to iterate through several values until you find the values that provide the best performance.
Configuration Parameter | Descriptions |
Default Execution Timeout | Sets the number of seconds that the data source waits for an execution to occur. If the limit is exceeded, a timeout occurs. If this value is zero, it means there is no limit. If it is greater than 0, the execution waits at most the given number of seconds. |
Delayed Connection Commit/Rollback Timeout | When the TDV Server is asked to rollback or commit a JDBC connection on a data source, it waits until all the result sets are closed. This timeout controls how long the server waits. After the timeout, if there are still open result sets, the connection is forcibly closed. If the timeout value is 0, the server does not timeout. The default is 300 seconds. |
5. Click Apply.
6. Click OK.
7. Restart the TDV Server to implement your changes.