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

조회 쿼리 성능 최적화 #61

Closed
Tracked by #57
, #62 ,  #63
...
LminWoo99 opened this issue May 25, 2024 · 1 comment · Fixed by #63
Closed
Tracked by #57
, #62 ,  #63
...

조회 쿼리 성능 최적화 #61

LminWoo99 opened this issue May 25, 2024 · 1 comment · Fixed by #63

Comments

@LminWoo99
Copy link
Owner

No description provided.

@LminWoo99 LminWoo99 mentioned this issue May 25, 2024
Closed
2 tasks
LminWoo99 added a commit that referenced this issue May 25, 2024
@LminWoo99
[#61]refactor(sns) : Optimize query performance using QueryDSL
226a1a8
@LminWoo99
Copy link
Owner Author

LminWoo99 commented May 25, 2024 •
edited
Loading

sns 게시글 전체 조회 쿼리 최적화

  • 더미 데이터 갯수 : 10000개

1. 여러개 쿼리

  • 속도 : 25sec 317ms

여러개 쿼리

2. querydsl 이용한 조인

  • 속도 : 505ms

조인쿼리

결론

엔티티를 여러 개 복잡한 조인하는 경우와 각각 따로따로 쿼리를 날리는 경우 성능 테스트 결과
한번에 조인하는 쿼리가 약 50배 빠른 성능을 보여준다

@LminWoo99 LminWoo99 mentioned this issue May 25, 2024
Merged
1 task
LminWoo99 added a commit that referenced this issue May 25, 2024
@LminWoo99
Merge pull request #62 from LminWoo99/feature/query-tuning
8e90b22 
[#61]refactor(sns) : Optimize query performance using QueryDSL
LminWoo99 added a commit that referenced this issue May 25, 2024
@LminWoo99
[#61]refactor(sns) : Optimize query performance using QueryDSL
efa3029
LminWoo99 added a commit that referenced this issue May 25, 2024
@LminWoo99
[#61]refactor(sns) : Optimize query performance using QueryDSL
48089d6
@LminWoo99 LminWoo99 mentioned this issue May 25, 2024
Merged
1 task
LminWoo99 added a commit that referenced this issue May 25, 2024
@LminWoo99
Merge pull request #63 from LminWoo99/hotfix/query-tuning
349c3b0 
[#61]refactor(sns) : Optimize query performance using QueryDSL
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

[#61]refactor(sns) : Optimize query performance using QueryDSL LminWoo99/PlantBackend
1 participant
@LminWoo99