Hibernate query optimization library

Question

Is there any libraries available that can be used to optimize hibernate queries?

I have tried searching for it, but what I found was the ways in which we could optimize sql queries.

Vlad Mihalcea · Accepted Answer · 2019-11-22 14:30:56Z

2

When it comes to JPA and Hibernate, you have to make sure the auto-generated SQL query is as efficient as the one you'd write using plain JDBC.

All in all, you have to analyze the SQL query execution plan and tune the query accordingly.

Now, there are all sorts of tools to help you with this task, like pt-query-advisor for MySQL.

Another option is to use Hypersistence Optimizer, which allows you to optimize your JPA and Hibernate mappings and configurations so that the auto-generated SQL queries are more efficient.

edited Nov 22, 2019 at 14:30

answered Feb 27, 2019 at 8:00

Vlad Mihalcea

156k85 gold badges599 silver badges984 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Andronicus · Accepted Answer · 2019-02-20 11:39:12Z

1

Hibernate optimizes queries itself, you need to fine-tune them by using caching and so on. Of course the most basic thing you can do is to log the sql queries and optimize them. You can also use something to manage your db connection, for example flexy-pool.

answered Feb 20, 2019 at 11:39

Andronicus

26.2k18 gold badges55 silver badges92 bronze badges

Collectives™ on Stack Overflow

Hibernate query optimization library

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related