+

Search Tips   |   Advanced Search

Data access tuning parameters

For better application performance, we can tune some data access resources through the WebSphere Application Server administrative console.

Tune these properties of data sources and connection pools to optimize the performance of transactions between the application and datastore.


Data source tuning

To view the administrative console page where we configure the following properties, click...


Connection pool tuning

To view the administrative console page where we configure the following properties, click...

        Resources > JDBC Providers > JDBC_provider > Data sources > data_source > Connection pool settings.

Maximum connections

Maximum number of physical connections that can be created in this pool. These are the physical connections to the backend datastore. When this number is reached, no new physical connections are created; requestors must wait until a physical connection that is currently in use is returned to the pool.

For optimal performance, set the value for the connection pool lower than the value for the web container threadpool size. Lower settings, such as 10 to 30 connections, might perform better than higher settings, such as 100. For more information about this setting, see the topic, Connection pool settings.

Default: 10

Minimum connections

Minimum number of physical connections to maintain. Until this number is exceeded, the pool maintenance thread does not discard physical connections.

If we set this property for a higher number of connections than the application ultimately uses at run time, we do not waste application resources. WAS does not create additional connections to achieve the minimum setting. Of course, if the application requires more connections than the value we set for this property, application performance diminishes as connection requests wait for fulfillment. For more information about this setting see the topic, Connection pool settings.

Default: 1


Related:

  • Connection pooling
  • Data sources
  • Configure a data source
  • Configure new data sources using wsadmin
  • Connection pool settings