FreeKB - Modify number of cached prepared statements in WebSphere
Modify number of cached prepared statements in WebSphere

Home > Search


By default, a WebSphere data source cache's 10 prepared statements. This can be seen and updated by navigating to Resources > JDBC > Data sources > select one of your data sourceWebSphere Application Server data source properties. Increasing this value may be beneficial if you anticipate an application using the data source will often need access to more than 10 prepared statements, as then the prepared statements can be obtained from cache which can reduce read in/out time.

 



Add a Comment




We will never share your name or email with anyone. Enter your email if you would like to be notified when we respond to your comment.




Please enter e0779 in the box below so that we can be sure you are a human.




Comments