Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[JPA] N+1 문제 - 실습 및 해결방안 #1

Closed
iseunghan opened this issue Feb 3, 2024 · 0 comments
Closed

[JPA] N+1 문제 - 실습 및 해결방안 #1

iseunghan opened this issue Feb 3, 2024 · 0 comments
Assignees
@iseunghan
Labels
JPA

Comments

@iseunghan
Copy link
Owner

iseunghan commented Feb 3, 2024 •
edited

도메인

Member(N) : Team(1) 연관관계로 테스트

테스트

  1. Member와 Team은 양방향으로 매핑
  2. Member.team (Eager), Team.members (Lazy) 전략일 때
  3. Member.team (Lazy), Team.members (Lazy) 전략일 때
  4. 해결(1) - FetchJoin 사용
  5. 해결(2) - Entity�Graph 사용
@iseunghan iseunghan added the JPA label Feb 3, 2024
@iseunghan iseunghan self-assigned this Feb 3, 2024
iseunghan added a commit that referenced this issue Feb 26, 2024
@iseunghan
#1 - Member.team (Eager), Team.members (Lazy) 전략일 때
8876410
iseunghan added a commit that referenced this issue Feb 26, 2024
@iseunghan
#1 - Member.team (Lazy), Team.members (Lazy) 전략일 때
854e361
iseunghan added a commit that referenced this issue Feb 26, 2024
@iseunghan
#1 - 해결(1) - FetchJoin 사용
66fe017
iseunghan added a commit that referenced this issue Feb 26, 2024
@iseunghan
#1 - 해결(2) - EntityGraph 사용
4b03918
iseunghan added a commit that referenced this issue Feb 28, 2024
@iseunghan
#1 - FetchJoin, EntityGraph는 Pagination을 사용할 수 없다
4b9c1cb
iseunghan added a commit that referenced this issue Feb 28, 2024
@iseunghan
#1 - 해결(3) - BatchSize (N+1)
67dc032
iseunghan added a commit that referenced this issue Feb 28, 2024
@iseunghan
#1 - 둘 이상의 컬렉션 Fetch Join 시 MultipleBagFetchException 발생
0844f14
iseunghan added a commit that referenced this issue Feb 28, 2024
@iseunghan
#1 - MultipleBagFetchException 해결방법 1 - Set 자료형
c63b5a0 
- 도메인의 자료형을 변경해야한다는 단점
- Pagination이 메모리에서 수행된다는 단점
iseunghan added a commit that referenced this issue Feb 28, 2024
@iseunghan
#1 - MultipleBagFetchException 해결방법 2 - List 자료형 + BatchSize
f2f6fa8 
- 도메인의 자료형을 변경해야한다는 단점 해결
- Pagination이 메모리에서 수행되는 점 해결
iseunghan added a commit that referenced this issue Feb 28, 2024
@iseunghan
#1 - JPA는 Fetch Join + ON절을 허용하지 않는다
3344aae
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@iseunghan iseunghan

Labels
JPA
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@iseunghan