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

[BE] 조회 쿼리 개선 #423

Open
4 tasks
parkmuhyeun opened this issue Sep 19, 2023 · 0 comments
Open
4 tasks

[BE] 조회 쿼리 개선 #423

parkmuhyeun opened this issue Sep 19, 2023 · 0 comments
Assignees
@parkmuhyeun @wonyongChoi05
Labels
🔨 Refactor
Milestone
5차 데모데이

Comments

@parkmuhyeun
Copy link
Member

parkmuhyeun commented Sep 19, 2023 •
edited
Loading

🔨 Describe

현재 불필요하게 여러개 쿼리가 날아가는 로직이나 인덱스로 개선이 가능한 쿼리들이 보여 리팩터링 할 예정입니다!

✅ Tasks

  • 사용하지 않는 컬럼 조회에서 제거
  • distinct 제거 -> group by로 카테시안 곱 해결
  • 한방 쿼리로 변경
  • 카운트 쿼리 최적화

🕖 예상 작업 소요 시간

1일

🙋🏻 More

No response
@parkmuhyeun parkmuhyeun added this to the 5차 데모데이 milestone Sep 19, 2023
@parkmuhyeun parkmuhyeun changed the title 쿼리 개선 쿼리 개선 + 인덱스 Sep 19, 2023
@wonyongChoi05 wonyongChoi05 changed the title 쿼리 개선 + 인덱스 [BE] 식품 조회 쿼리 개선 Sep 20, 2023
@parkmuhyeun parkmuhyeun changed the title [BE] 식품 조회 쿼리 개선 [BE] 조회 쿼리 개선 Sep 20, 2023
@parkmuhyeun parkmuhyeun mentioned this issue Sep 20, 2023
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@parkmuhyeun parkmuhyeun

@wonyongChoi05 wonyongChoi05

Labels
🔨 Refactor
Projects
2023-zipgo
Status: In Progress
Milestone
5차 데모데이
Development

No branches or pull requests
2 participants
@parkmuhyeun @wonyongChoi05