Re: Database related performance degradation after upgrading from Tomcat 9.0.33 to Tomcat 9.0.69

2023-02-24 Thread Christopher Schultz
Artur, On 2/23/23 15:55, Artur Tomusiak - Hannon Hill wrote: Thanks everyone for the information and advice. Thanks to you we were able to track this down to a specific version of Tomcat and DBCP. Simply copying tomcat-dbcp.jar file from Tomcat 9.0.38 to Tomcat 9.0.33 and running Tomcat 9.0.33

Re: Database related performance degradation after upgrading from Tomcat 9.0.33 to Tomcat 9.0.69

2023-02-24 Thread Mark Thomas
On 23/02/2023 20:55, Artur Tomusiak - Hannon Hill wrote: A few follow up questions: - Which of the two workarounds would be more recommended? Would there be any problems with mismatching tomcat-dbcp.jar version or with using the useLocalSessionState parameter? It depends. Given

Re: Database related performance degradation after upgrading from Tomcat 9.0.33 to Tomcat 9.0.69

2023-02-23 Thread Artur Tomusiak - Hannon Hill
Thanks everyone for the information and advice. Thanks to you we were able to track this down to a specific version of Tomcat and DBCP. Simply copying tomcat-dbcp.jar file from Tomcat 9.0.38 to Tomcat 9.0.33 and running Tomcat 9.0.33 results in the slowness. This means that the issue was

Re: Database related performance degradation after upgrading from Tomcat 9.0.33 to Tomcat 9.0.69

2023-02-22 Thread Mark Thomas
On 22/02/2023 04:58, Konstantin Kolinko wrote: ср, 22 февр. 2023 г. в 01:31, Artur Tomusiak - Hannon Hill : After upgrading from Tomcat 9.0.33 to Tomcat 9.0.69, Note that using a binary search (bisection) one could limit the version range. Relevant version information is: 9.0.71 - DBCP

Re: Database related performance degradation after upgrading from Tomcat 9.0.33 to Tomcat 9.0.69

2023-02-21 Thread Terence M. Bandoian
On 2/21/2023 10:58 PM, Konstantin Kolinko wrote: ср, 22 февр. 2023 г. в 01:31, Artur Tomusiak - Hannon Hill : After upgrading from Tomcat 9.0.33 to Tomcat 9.0.69, Note that using a binary search (bisection) one could limit the version range. If I understand the point you're making: If

Re: Database related performance degradation after upgrading from Tomcat 9.0.33 to Tomcat 9.0.69

2023-02-21 Thread Konstantin Kolinko
ср, 22 февр. 2023 г. в 01:31, Artur Tomusiak - Hannon Hill : > > After upgrading from Tomcat 9.0.33 to Tomcat 9.0.69, Note that using a binary search (bisection) one could limit the version range. Alternatively, it is possible to reconfigure the pool to use Apache Commons DBCP 2 and Apache

RE: Database related performance degradation after upgrading from Tomcat 9.0.33 to Tomcat 9.0.69

2023-02-21 Thread John.E.Gregg
Artur, > -Original Message- > From: Artur Tomusiak - Hannon Hill > Sent: Tuesday, February 21, 2023 4:31 PM > To: users@tomcat.apache.org > Subject: Database related performance degradation after upgrading from > Tomcat 9.0.33 to Tomcat 9.0.69 > > After upgr

Database related performance degradation after upgrading from Tomcat 9.0.33 to Tomcat 9.0.69

2023-02-21 Thread Artur Tomusiak - Hannon Hill
After upgrading from Tomcat 9.0.33 to Tomcat 9.0.69, jobs in our application that execute lots of quick database queries end up being visibly slower - 16% slower on average in a typical setup where a database is on a local area network. Here is additional information we have confirmed: - This