Optimization - N+1 Problem Solutions - Join Fetch

In this video, shows you how to use "join fetch" to solve N+1 problem. If you don't understand the problem, it's better you watch N+1 problem and Entity Graph to understand the problem first.
source code: github.com/Tin...

[@rotjko9268]

You can use the FETCH clause with both LEFT and (INNER) JOINS, so either LEFT JOIN FETCH or JOIN FETCH

[@PradeepKumar-db7pe]

I saw redundant duplicates and then see the same in your console output as well. Address for Person1 is being repeated 3 times in the output. I used select distinct p.. To resolve the same.

[@davaa847]

:) your attitude is making me want to watch next video

[@DanielLee-xo2op]

Thanks for the helpful video. The join fetch and entity graph can resolve the n+1 issue in the case of joining by id. However, when I try to do join fetch in sql with multiple joined columns (like first name and last name), the n+1 will happen. It seems that hibernate doesn't help to eliminate n+1 with fetch joining multiple columns. Can you give advice ?

[@MakeItStik]

Hi, were you able to find a solution to this problem?

[@AlexeySilichenko]

This video great as well, thank you very much!

[@HappyYourSelf]

Can you teamview to fix help this error. Please

[@PradeepKumar-db7pe]

I liked, Shared and subscribed your channel😀. Thanks you!

[@dinazainetdinova3652]

Thank you!

[@JocylineMagero]

Very helpful videos

[@davaa847]

You mentioned :)

[@RelaxationMusic-nb6pk]

This is helpfull Nice Video....Thank You!!!!!!!!!!!

[@HappyYourSelf]

I love you !!!!