There are a lot of things you can parameterise on JAVA connection as well as on the connections pool.

Some of the parameters support the communication with database or the caching behaviour and others influence the management of connections. Each case is different and you have to bring some experience as well as experiments to the setting right for your application. Here are some links to find more details on JAVA connections.

In general – but this is valid for all languages – the use of prepare statements will typical improve the performance. Yes, it is a bit more overhead for the application but you get the effort back by better responding application. Of course there are also exceptions where a prepare statement is less effective.

Find here a collection of settings that you might want to consider for your application. This is a list of parameter that was valid for this particular application. Here we want to show up the possibilities you have to optimise the performance of your application. It may also happen that you decrease the applications performance having the this parameters. But you should know that you have them.

 

nonBlockingIO                  =false  link
timeZonePerObject              =false  link
packetSize                     =130000 link
closeHandlesByCleaner          =false  link
transactionalLobs              =false  link
maxLazyDroppedStatements       =100    link
statementCacheSize             =500    link
deferredPrepare                =true   link 


Other readings

Connection pool parameters 

 

Sara Sampaio

Sara Sampaio

Author Since: March 10, 2022

0 0 votes
Article Rating
Subscribe
Notify of
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x