High-Performance Java Persistence Newsletter, Issue 59
Imagine having a tool that can automatically detect JPA and Hibernate performance issues. Wouldn’t that be just awesome?
Well, Hypersistence Optimizer is that tool! And it works with Spring Boot, Spring Framework, Jakarta EE, Java EE, Quarkus, or Play Framework.
So, enjoy spending your time on the things you love rather than fixing performance issues in your production system on a Saturday night!
Introduction
Welcome to a new issue of the High-Performance Java Persistence Newsletter in which we share articles, videos, workshops, and StackOverflow answers that are very relevant to any developer who interacts with a database system using Java.
Articles
The pick of this week is this article written by Lukas Eder about various query optimizations the database can do to speed up query executions. If you want to get a better understanding of SQL execution plans, this article is surely going to help you in this regard.
If you’re using a database system, then you should definitely write integration tests to validate the functionality of your data access layer. So, if you want to know the best way to achieve this goal, then check out this article.
Speaking of testing, if you need to check how your data access layer behaves in a concurrent environment, then you can use the Java CountDownLatch. If you want to know how to use this Java concurrency utility, then check out this article.
When choosing the database table identifier, you can either use an auto-incremented numerical value, such as IDENTITY or SEQUENCE or a UUID that you can generate in the application. However, as I explained in this article, using UUIDs can lead to performance issues. If you are interested in this topic, then check out this article written by Franck Pachot.
Fetching recursive associations can be done in several ways when using JPA and Hibernate. So, if you plan on modeling hierarchical data structures in your relational database, then you should definitely read this article that dives into this particular topic.
Project Releases
Hibernate ORM released the 6.4.2 version, and it brings lots of bug fixes for the 6.4 version. If your Spring Boot or Spring application uses Hibernate 6.4, then you might want to upgrade the Hibernate version to this latest version.
The 3.7.1 version of Hypersistence Utils project has been released, and it brings support for Hibernate 6.4. So, if you plan on upgrading your application to Spring Boot 3.2.2, then you should definitely upgrade the Hypersistence Utils library as well.
The 2.8.2 version of the Hypersistence Optimizer was released with a fix for JTA environments.
MySQL has released the 8.0.36 version and provides many bug fixes that you might want to benefit from.
Get in touch with my latest articles!
StackOverflow Answers
The following StackOverflow answers have been trending since the last newsletter episode:
- Compile Maven Module with Different Java Version
- How to process large amounts of data using Hibernate
- What is better for performance – Make a bulk call to DB or a Nested Loop with multiple calls?
- Spring Data mapping doesn’t work as expected
- Difference between “select t from table t” and “from table” in HQL
