We have recently upgraded our application to hibernate 6. After upgrade, its taking double the time (it used to take before upgrade) to run the journey. I have printed the stats and have one observation.
Before upgrade:
Session Metrics {
425000 nanoseconds spent acquiring 1 JDBC connections;
0 nanoseconds spent releasing 0 JDBC connections;
191800 nanoseconds spent preparing 2 JDBC statements;
5565500 nanoseconds spent executing 2 JDBC statements;
0 nanoseconds spent executing 0 JDBC batches;
0 nanoseconds spent performing 0 L2C puts;
0 nanoseconds spent performing 0 L2C hits;
0 nanoseconds spent performing 0 L2C misses;
0 nanoseconds spent executing 0 flushes (flushing a total of 0 entities and 0 collections);
0 nanoseconds spent executing 0 partial-flushes (flushing a total of 0 entities and 0 collections)
}
After upgrade:
Session Metrics {
485400 nanoseconds spent acquiring 1 JDBC connections;
0 nanoseconds spent releasing 0 JDBC connections;
159100 nanoseconds spent preparing 2 JDBC statements;
12265000 nanoseconds spent executing 2 JDBC statements;
0 nanoseconds spent executing 0 JDBC batches;
0 nanoseconds spent performing 0 L2C puts;
0 nanoseconds spent performing 0 L2C hits;
0 nanoseconds spent performing 0 L2C misses;
0 nanoseconds spent executing 0 flushes (flushing a total of 0 entities and 0 collections);
0 nanoseconds spent executing 0 partial-flushes (flushing a total of 0 entities and 0 collections)
}
The time taken to acquire JDBC connection and to execute statements has increased after upgrade.
Any thing you can suggest on this? Any leads to investigate this issue further will also be helpful. Please let us know if you need any more information. Thanks.