Imagine having a tool that can automatically detect JPA and Hibernate performance issues. Wouldn’t that be just awesome?

Why you should use compact table columns - Vlad Mihalcea

submited by

Style Pass

2025-01-14 15:00:05

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!

As I explained in this article, relational database systems cache the pages that are loaded from the disk in the Buffer Pool (e.g., shared buffers in PostgreSQL) so that the next time the same page is requested by an SQL query execution, the page will be served from the memory (logical read) instead of from the disk (physical read).

Even if an SSD (Solid State Drive) is very fast compared to the traditional HDD (Hard Disk Drive), RAM is still orders of magnitude faster than SSD, so it makes sense to try to store the working set of data in memory instead of having to load it from the disk on every SQL query execution.