How To Fetch DTO Via javax.persistence.Tuple And Native SQL
Description: Fetching more data than needed is prone to performance penalities. Using DTO allows us to extract only the needed data. In this application we rely on javax.persistence.Tuple and native SQL.
Key points:
- use
java.persistence.Tuplein a Spring repository and mark the query asnativeQuery = true - for using Spring Data Projections check this item
| 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. |
|
|
|
