Skip to content

Files

Latest commit

 

History

History

HibernateSpringBootSpecificationQueryFetchJoins

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
 
 
 
 
 
 

How To Create Specification Query Fetch Joins

Description: This application contains two examples of how to define JOIN in Specification to emulate JPQL join-fetch operations.

Key points:

  • the first approach trigger two SELECT statements and the pagination is done in memory (very bad!)
  • the second approach trigger three SELECT statements but the pagination is done in the database
  • in both approaches the JOIN is defined in a Specification implementation

If you need a deep dive into the performance recipes exposed in this repository then I am sure that you will love my book "Spring Boot Persistence Best Practices"If you need a hand of tips and illustrations of 100+ Java persistence performance issues then "Java Persistence Performance Illustrated Guide" is for you.