Hi all, Tomcat Version - 8.5.55 OS - OL7
I'm working with an application team that wishes to set the timeBetweenEvictionRunsMillis setting of their database connection pool to a very low setting - 20ms. According to the documentation (https://tomcat.apache.org/tomcat-8.5-doc/jdbc-pool.html), this setting should never be set below 1000ms, so I'm weary to allow this. Their claim is that application performance is poor when set to our default of 2000ms. To me this indicates that there is a bug in the application itself not closing connections after it is done with them and have to wait for an idle connection to be created by the pool, causing the performance lag. I'm curious if this advice in the documentation is given based on performance concerns or if there is some other underlying issue that could present itself if this setting is below 1000 ms? Thanks! CONFIDENTIALITY NOTICE This e-mail message and any attachments are only for the use of the intended recipient and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient, any disclosure, distribution or other use of this e-mail message or attachments is prohibited. If you have received this e-mail message in error, please delete and notify the sender immediately. Thank you.
