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

[Feature] JPA N+1 수정, 페이징 조회 최적화 #138

Open
11 of 15 tasks
kwonssshyeon opened this issue Nov 25, 2024 · 0 comments · Fixed by #146
Open
11 of 15 tasks

[Feature] JPA N+1 수정, 페이징 조회 최적화 #138

kwonssshyeon opened this issue Nov 25, 2024 · 0 comments · Fixed by #146
Assignees
@kwonssshyeon

Comments

@kwonssshyeon
Copy link
Member

kwonssshyeon commented Nov 25, 2024 •
edited
Loading

🛠️ 계획된 기능

  • N+1이 발생하는 구간을 확인하고 수정할 수 있으면 수정
  • 페이징에서 count쿼리가 필요없는 경우 고려
  • count 쿼리 따로 작성한 부분들 Page 객체 반환으로 해결할 수 있는지 고려
  • 중복 쿼리 최소화
  • DTO로 반환할 쿼리들 수정
  • 애플리케이션에서 필터링하는 코드 수정 고려
  • 개발 서버 더미 데이터 추가
  • 잘못된 cascade 옵션 수정

+) DDL 수정이 많으면 Flyway 도입 고려해보기

🛠 기능 구현 세부사항

  • N+1 확인
  • user
  • application
  • member(admin)
  • post
  • comment
  • team

🛠 참고사항

📝 check-lists

  • 수정 전/후 성능 테스트 해보기
@kwonssshyeon kwonssshyeon self-assigned this Nov 25, 2024
@kwonssshyeon kwonssshyeon mentioned this issue Dec 16, 2024
Merged
6 tasks
@kwonssshyeon kwonssshyeon linked a pull request Dec 16, 2024 that will close this issue
JPA N+1 수정, 페이징 조회 최적화 #146
Merged
6 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@kwonssshyeon kwonssshyeon

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

JPA N+1 수정, 페이징 조회 최적화 GDG-on-Campus-KNU/GDG_onCampus_KNU_Official_BE
1 participant
@kwonssshyeon