High-Performance Java Persistence Newsletter, Issue 48

Last modified:

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 edition is this article that explains why an SQL Server query executed by an application can have a different response time than if it were run on the SQL Server Management Studio.

Another great read is this article about the performance difference between composite indexes and merged indexes when using MySQL and PostgreSQL.

A few months ago, I wrote this article, which explains why UUID version 4 is not suitable for Primary Key values that are indexed using B+Tree and why a compact time-sorted identifier may provide better performance.

You can now use the Hypersistence Utils library to generate the TSID values automatically for your JPA and Hibernate entities. Check out this article for more details.

A very useful resource is this tutorials page, which provides several articles about distributed systems.

Speaking of distributed systems, I also wrote several articles about YugabyteDB, which is a very compelling distributed SQL database:

Videos

I uploaded the second video of the Shopizer performance tuning series:

This video is part of a series of videos about optimizing Java applications using the amazing Hypersistence Optimizer.

Best Tweets

Here are the best tweets I posted since the last newsletter:

The best way to log SQL statements with Spring Boothttps://t.co/23aHhyjBEv pic.twitter.com/ThgrE38BZQ
— Vlad Mihalcea (@vlad_mihalcea) February 20, 2023

Soon, this is how you will be able to generate Time-Sorted ids with Hibernate 6 and the amazing Hypersistence Utils OSS library. pic.twitter.com/rjckjWBMrl
— Vlad Mihalcea (@vlad_mihalcea) February 15, 2023

The best way to do the Spring 6 migrationhttps://t.co/CKBbZUIxAD pic.twitter.com/cR6gztyaFS
— Vlad Mihalcea (@vlad_mihalcea) February 20, 2023

Spring Boot Application Propertieshttps://t.co/0Qhhhs1AOE pic.twitter.com/FsvDhL2DYR
— Vlad Mihalcea (@vlad_mihalcea) February 23, 2023

How distributed SQL databases work - YugabyteDB Architecturehttps://t.co/DekkvQupra pic.twitter.com/wh1jTktkY4
— Vlad Mihalcea (@vlad_mihalcea) February 23, 2023

Project Releases

The 3.2 version of the amazing Hypersistence Utils OSS project has been released and provides you with a TSID generator that can automatically allocate time-sorted identifiers for your JPA and Hibernate entities.

Hibernate ORM released two versions for the 6.1 and 5.6 branches that provide several bug fixes:

6.1.7
5.6.15

The 15.2 version of PostgreSQL has been released. This version provides a lot of fixes that were identified in the previous versions, so if you’re using 15.1 or 15.0, you may want to consider upgrading to 15.2.

The 12.2 version of the Microsoft JDBC Driver was released, providing support for Java 19. For instance, there’s an optimization that replaces synchronized blocks with reentrant locks, therefore improving the application performance on Loom.

The Spring Data JPA 3.0.2 has been released, providing several bug fixes.