High-Performance Java Persistence Newsletter, Issue 49
Are you struggling with performance issues in your Spring, Jakarta EE, or Java EE application?
What if there were a tool that could automatically detect what caused performance issues in your JPA and Hibernate data access layer?
Wouldn’t it be awesome to have such a tool to watch your application and prevent performance issues during development, long before they affect production systems?
Well, Hypersistence Optimizer is that tool! And it works with Spring Boot, Spring Framework, Jakarta EE, Java EE, Quarkus, Micronaut, or Play Framework.
So, rather than fixing performance issues in your production system on a Saturday night, you are better off using Hypersistence Optimizer to help you prevent those issues so that you can spend your time on the things that you love!
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 edition is this article, which explains the performance optimizations done by the Quora engineering team to scale their MySQL database cluster. MySQL is an amazing database product that powers some of the largest applications over the Internet like Facebook, Pinterest, and Shopify, to name a few.
For performance tuning, if you want to avoid blocking, you can use NO WAIT, as explained by this article. The nice thing about NO WAIT is that all major database systems support it (e.g., Oracle, SQL Server, MySQL, or PostgreSQL).
Another great article about MySQL is this one that explains various settings you need to take into consideration when improving the performance of your MySQL database system.
If you’re using PostgreSQL, then check out this article, which explains how TRUNCATE works under the hood and how it’s possible for PostgreSQL to offer a transactional TRUNCATE operation that can be rolled back.
If you are using Spring and Spring Data JPA, I wrote three articles that could help you get the most out of your data access layer:
- The best way to use Spring Data query methods
- The best way to use JOIN FETCH and Pagination with Spring
- The best way to use the Spring Data JPA Specification
Videos
I uploaded the third part of the Shopizer performance tuning series:
This video shows you how to optimize a non-trivial Java application using the amazing Hypersistence Optimizer.
Best Tweets
Here are the best tweets I posted since the last newsletter:
19 years ago today, the 1.0 version of the Spring framework was released.
— Vlad Mihalcea (@vlad_mihalcea) March 24, 2023
I started using it in November 2004 and instantly forgot about the J2EE madness.https://t.co/JWcjelCaUQ pic.twitter.com/G4DrnvdBAX
Junior developer after reading High-Performance Java Persistence https://t.co/WiDwZsM1y8 pic.twitter.com/NKObmcPe35
— Vlad Mihalcea (@vlad_mihalcea) March 16, 2023
The best way to log SQL statements with Spring Boothttps://t.co/23aHhyk9u3 pic.twitter.com/FVFWuhL1wE
— Vlad Mihalcea (@vlad_mihalcea) March 23, 2023
Most exciting software products are built using boring tech
— Vlad Mihalcea (@vlad_mihalcea) March 21, 2023
SQL Recursive WITH CTE querieshttps://t.co/ekbeWcukvH pic.twitter.com/PwbRJUVyBN
— Vlad Mihalcea (@vlad_mihalcea) April 3, 2023
Project Releases
Hibernate ORM released the 6.2.0 version, which brings support for CTE and Recursive CTE in JPQL and Criteria API query.
Hypersistence Utils has released two versions:
The Hypersistence Utils 3.3 branch adds support for Hibernate ORM 6.2 and introduces a new type that supports the PostgreSQL ltree column type.
The Spring Data JPA 3.0.4 has been released, allowing you to use Hibernate ORM 6.2.
Get in touch with my latest articles!
StackOverflow Answers
The following StackOverflow answers have been trending since the last newsletter episode:
- How to persist entities using multiple processing threads with JPA and Hibernate
- Hibernate mapping between PostgreSQL enum and Java enum
- How to fix the “No Dialect mapping for JDBC type: 1111” issue
- How does the FetchMode work in Spring Data JPA
- Does Hibernate ORM support XML-based entity mappings?
