Hello! We recently upgraded from Java 8 to 17 and in doing so we switched Hibernate Core from 5.4.17.Final to 6.5.3.Final. Now we encountered this weird bug, when a QueryDSL query gets executed for the first time it takes way more time it did before the upgrade. Before the upgrade when the query g…

In comparison, profiling the same query before upgrading: [grafik] (I couldn’t upload it to the first post due to restrictions of being a new user.)

What are these flamegraph measuring, the wall-clock time for each call? I find it very weird ANTLr parsing takes ~1.5 seconds, could you please paste the query string it’s trying to process? You could try comparing a pure Hibernate application (without QueryDSL in the way) and comparing performance…

What are these flamegraph measuring, the wall-clock time for each call? No, it’s CPU time. Sorry for forgetting to mention. could you please paste the query string it’s trying to process? This is the query that get’s generated: select ke1_0.domain_object_id, ke1_0.stubObject_creationDateTime,…

Hello, I believe I’m experiencing similar issue. After Spring Boot (2.7 → 3.4) and Hibernate (5.6.15 → 6.6.5.Final) upgrades, the very first query execution is about 40 times slower. I use Blaze on top of Spring Data JPA to build my query. I have tried to downgrade Hibernate (along with Boot) to 6.…

Please try to create a reproducer with our test case template and if you are able to reproduce the issue, create a bug ticket in our issue tracker and attach that reproducer.

Sorry for not responding earlier. I have been tasked with other stuff. I did manage to build the query with just JPQL and the performance is nearly the same as with QueryDSL. But, I downgraded hibernate-core to 6.2.33.Final and the query execution time did improve significantly. With version 6.6.5…

[image] domids: Btw org.hibernate.cfg.QuerySettings.QUERY_PLAN_CACHE_ENABLED mentions that it is disabled by default. However, in org.hibernate.query.internal.QueryEngineImpl.buildInterpretationCache it is enabled by default The javadoc is wrong then. Would appreciate a PR with a fix for that…

The javadoc is wrong then. Would appreciate a PR with a fix for that. PR: HHH-19208 Adapt javadoc of QuerySettings.QUERY_PLAN_CACHE_ENABLED by domids · Pull Request #9813 · hibernate/hibernate-orm · GitHub

I tried to explicitly disable it but I couldn’t figure out how to do it in a Spring Boot Data JPA project. Do you know how to do that? I figured it out - you have to use spring.jpa.properties.hibernate.query.plan_cache_enabled in your application.properties. However, this wasn’t the culprit of t…

I managed to reproduce the issue with the test case template. Hibernate 5 Test Case: hibernate-test-case-templates/orm/hibernate-orm-5/src/test/java/org/hibernate/bugs/JPAUnitTestCase.java at main · domids/hibernate-test-case-templates · GitHub Executing the test in IntelliJ took about 0.6 seconds.…

After upgrade to Hibernate 6 slower performance when executing query the first time due to ANTLR?

Hibernate ORM

beikov February 26, 2025, 3:32pm 8

The javadoc is wrong then. Would appreciate a PR with a fix for that.

No idea.

Topic		Replies	Views
Query performance regressions in Hibernate 6 Hibernate ORM	38	4072	October 30, 2023
Hibernate v5->v6 upgrade - poor query performance Hibernate ORM	3	1167	December 10, 2022
Slower performance after upgrading hibernate from 5.6.15.Final to 6.2.2.Final Hibernate ORM	3	1016	August 1, 2023
Performance hit from 5.6.9 to 6.1.2 Hibernate ORM	10	6041	August 5, 2022
Hibernate 6 JPA performance degradation Hibernate ORM	1	917	January 17, 2024

After upgrade to Hibernate 6 slower performance when executing query the first time due to ANTLR?

Related topics