How to use JPA Hibernate with tons of coupled entities

Question

I'm working in a project and we have tons of data for each call that we are doing from the front-end to the back-end.

The thing is that we have a really huge database and we have tons of coupled entities.

For example, we have to bring the user, but it has an "address" object with a lot of information, and also this has a "city" object with more information, and then we have "zip code" same and so...

The thing is that we are facing some performance issues when we have some concurrent users. We are creating a query for each user, and then another one for each address, and then another one for each city... The thing is that when we are getting all the users all this nested objects, even if it's the same city, we create a SQL for each user.

Can we use something in hibernate to improve this performance?

Thank you so much Best regards

You will find a lot of posts on this performance strategy you can start with in this one : https://stackoverflow.com/questions/32453989/what-is-the-solution-for-the-n1-issue-in-jpa-and-hibernate — Pierre Demeestere, Nov 28 '22 at 09:50

Shakirov Ramil · Answer 1 · 2022-11-28T10:09:11.773

0

use Hibernate Second-Level Cache
Lazy loading
@Batch

edited Nov 28 '22 at 10:09

answered Nov 28 '22 at 10:03

Shakirov Ramil

1,381
9
13

How to use JPA Hibernate with tons of coupled entities

1 Answers1