Fix N+1 Select Issues with Hibernate’s EntityGraphs

[@pedrolopezmartinez7631]

Thank you for sharing, Thorben. Very useful your explanation, as always.

[@Thorben-Janssen]

Thanks Pedro!

[@ferlezcano]

Thorben, great video as always! 💪

[@Thorben-Janssen]

Appreciate it!

[@chanchhaya]

Thank you for sharing, teacher

[@Thorben-Janssen]

Thanks for watching :)

[@mjr-g5d]

How can I make a composite primary key but this compsite primary key contains tow or more fields coming from another class as a foreign key in jpa

[@MrMikopi]

Small question on the last part: Does that mean that it's a good practice to store all ToMany relations in Set?

[@Thorben-Janssen]

Yes, it is. It enables you to fetch multiple of them using JOIN FETCH clauses or EntityGraphs, and avoids some inefficient handling of many-to-many relationships

[@Baalerion]

What if the books can be of a different subclasses and you want to fetch the attributes that exist only on a given subclass? For example if some books are of a subclass "ScienceBook" that have a field scienceFacts and you want to fetch that also?

[@Thorben-Janssen]

Hibernate automatically fetches the correct subclass if you annotate your entity classes with @Inheritance to map your inheritance hierarchy

[@alexmorland1619]

Nice

[@Thorben-Janssen]

Thanks

[@erikgollot6331]

You should talk about cartesian product in your 2nd example. You say huge but do not give enough example to my opinion You should also insist on duplication of data on each row

[@Thorben-Janssen]

Thanks for the feedback. That's what I meant, when I spoke about the author who wrote 5 books with 100 reviews. I explained that in more details in the previous video and didn't want to repeat myself. Maybe that was the wrong decision

[@krasnoj]

​@@Thorben-Janssen For me, everything was clear. Also for erikgollot6331 was everything clear, else he could not made this suggestion.

[@erikgollot6331]

I hope you will talk about @BatchSize next

[@MrMikopi]

Yes! I would especially be interested with: Setting batch sizes that effect all project vs setting a batch size for specific methods (batch / bulk methods for example).