Tuning Data Source
You can use data source tuning to boost the performance of the relational data source in the server application. Allocating and deallocating resources for data sources is not so easy in terms of time and system resources. During the application startup, you can create a pool of database connections in advance and make these connections available to the application.
For TIBCO Order Management, you can configure the following properties for data source tuning as per your requirements. For description and more information about the properties, see the Tomcat JDBC Connection Pool documentation.
Microservice | Property | Description |
---|---|---|
AOPD | catalogDsTestOnBorrow | Enables connection validation before being borrowed from the pool |
catalogDsValidationInterval | Data source validation interval in milliseconds | |
catalogDsTestWhileIdle | Enables connection validation while idle in the connection pool | |
catalogDsTimeBetweenEvictionRunsMillis | Data source eviction interval in milliseconds | |
catalogDsMinEvictableIdleTimeMillis | Minimum time in milliseconds an object must sit idle in the pool before it is eligible for eviction | |
catalogDsNumTestsPerEvictionRun | Data source tests per eviction run | |
catalogDsDefaultAutoCommit | Default auto-commit state of connections created by this pool | |
catalogDsRollbackOnReturn | Enables rollback of any pending transaction when a connection is returned to the pool | |
catalogDsCommitOnReturn | Enables commit of any pending transaction when a connection is returned to the pool | |
catalogDsCustomProperty | Database custom property | |
Orchestrator | catalogDsInitializeSize | Number of connections established when the connection pool starts |
catalogDsMaxIdle | Maximum number of connections to keep in the idle pool | |
catalogDsMaxActive | Maximum number of active connections that can be allocated from this pool at the same time | |
catalogDsMaxWait | Maximum time in milliseconds the pool will wait when there are no available connections | |
catalogDsTestOnBorrow | Enables connection validation before being borrowed from the pool | |
catalogDsValidationInterval | Data source validation interval in milliseconds | |
catalogDsTestWhileIdle | Enables connection validation while idle in the connection pool | |
catalogDsTimeBetweenEvictionRunsMillis | Data source eviction interval in milliseconds | |
catalogDsMinEvictableIdleTimeMillis | Minimum time in milliseconds an object must sit idle in the pool before it is eligible for eviction | |
catalogDsNumTestsPerEvictionRun | Data source tests per eviction run | |
catalogDsDefaultAutoCommit | Default auto-commit state of connections created by this pool | |
catalogDsRollbackOnReturn | Enables rollback of any pending transaction when a connection is returned to the pool | |
catalogDsCommitOnReturn | Enables commit of any pending transaction when a connection is returned to the pool | |
catalogDsCustomProperty | Database custom property | |
Archival | archivalHibernateShowSql | Enables Hibernate to show queries |
archivalDsInitialSize | Number of connections established when the connection pool starts | |
archivalDsMaxWait | Maximum time in milliseconds the pool waits for a connection to be returned before throwing an exception | |
archivalDsMaxActive | Maximum number of active connections that can be allocated from this pool at the same time | |
archivalDsMaxIdle | Maximum number of connections to keep in the idle pool | |
archivalDsMinIdle | Minimum number of established connections to keep in the pool at all times | |
archivalDsTestOnBorrow | Pooled data source test on borrow | |
archivalDsValidationInterval | Pooled data source validation interval | |
Catalog | catalogDsMaxIdle | Maximum number of connections to keep in the idle pool |
catalogDsMaxActive | Maximum number of active connections that can be allocated from this pool at the same time | |
catalogDsMaxWait | Maximum time in milliseconds the pool will wait when there are no available connections | |
catalogDsTestOnBorrow | Enables connection validation before being borrowed from the pool | |
catalogDsValidationInterval | Data source validation interval in milliseconds | |
catalogDsTestWhileIdle | Enables connection validation while idle in the connection pool | |
catalogDsTimeBetweenEvictionRunsMillis | Data source eviction interval in milliseconds | |
catalogDsMinEvictableIdleTimeMillis | Minimum time in milliseconds an object must sit idle in the pool before it is eligible for eviction | |
catalogDsNumTestsPerEvictionRun | Data source tests per eviction run | |
catalogDsDefaultAutoCommit | Default auto-commit state of connections created by this pool | |
catalogDsRollbackOnReturn | Enables rollback of any pending transaction when a connection is returned to the pool | |
catalogDsCommitOnReturn | Enables commit of any pending transaction when a connection is returned to the pool | |
catalogDsCustomProperty | Database custom property |