High-Performance Java Persistence Newsletter, Issue 30

Imagine having a tool that can automatically detect JPA and Hibernate performance issues. Hypersistence Optimizer is that tool!

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 written by Franck Pachot about PostgreSQL statement caching and how generic plans are generated.

When using PostgreSQL, then you should definitely read this article which explains how to get an Index Only Scan instead of an Index Scan when executing a query that contains a function expression.

Keyset pagination is a very efficient pagination mechanism, especially when navigating large result sets. Even if JPA and Hibernate don’t offer built-in support for Keyset pagination, Blaze Persistence allows you to build Keyset pagination queries dynamically. For more details about this feature, check out this article.

If you are using MySQL, this article shows you how to store and query JSON objects.

SQL provides a wide range of features that are very often overlooked. For instance, if you want to override the default SQL operation order, you can use derived tables or CTE. And if you want to learn more about these very useful SQL features, you can read the following two articles:

A very important thing I’ve learned from this article is that MySQL stores in memory the row modification counter that triggers the index statistics update. For this reason, a server restart might delay the index statistics updates, therefore influencing the effectiveness of SQL query execution plans. If you’re interested in this topic, Jesper Wisborg Krogh explains it in great detail in this article.

Best Tweets

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

Project Releases

The 2.4.2 version of the amazing Hypersistence Optimizer has been released. If you are using JPA and Hibernate, this tool will help you speed up your data access layer so that you can focus on providing business value rather than solving complex performance issues.

PostgreSQL 13.2 has been released and provides many new features and bug fixes as well.

Hibernate ORM 5.5.6 and 5.5.7 have been released, and a new 5.6 branch was created to help you migrate to version 6.

Get in touch with my latest articles!

StackOverflow Answers

The following StackOverflow answers have been trending over the past two weeks:

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.