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

여행 생성 및 여행 상세 조회 쿼리 개선 #645

Closed
6 tasks done
jjongwa opened this issue Sep 28, 2023 · 0 comments · Fixed by #651
Closed
6 tasks done

여행 생성 및 여행 상세 조회 쿼리 개선 #645

jjongwa opened this issue Sep 28, 2023 · 0 comments · Fixed by #651
Assignees
@hgo641 @jjongwa
Labels
BE 🔨 Refactor

Comments

@jjongwa
Copy link
Member

jjongwa commented Sep 28, 2023 •
edited
Loading

🔨 Describe

현재 최악의 경우

  • 여행 생성: 110개 쿼리 발생 -> 4개로 줄이는게 목표
  • 단일 여행 상세 조회: 3,882개 쿼리 발생 -> 5개로 줄이는게 목표

✅ Tasks

  • 여행 생성
    • saveAll 문제 해결
    • tripCity 쪽 쿼리 개선
  • 여행 상세 조회
    • 아이템 조회 N+1문제 해결
    • daylog, item, city 한꺼번에 조회하도록 조인 쿼리 작성

🙋🏻 More

홍박사님과 함께하는 추석 특집 이벤트
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@hgo641 hgo641

@jjongwa jjongwa

Labels
BE 🔨 Refactor
Projects
2023-hang-log
Status: Done
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

여행 생성 및 여행 상세 조회 쿼리 개선 woowacourse-teams/2023-hang-log
2 participants
@hgo641 @jjongwa