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.

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

[BE] Submission 조회 성능 개선 #658

Open
cndqjacndqja opened this issue Oct 30, 2022 · 0 comments
Open

[BE] Submission 조회 성능 개선 #658

cndqjacndqja opened this issue Oct 30, 2022 · 0 comments
Assignees

Comments

@cndqjacndqja
Copy link
Collaborator

현재 submission 조회 쿼리가 offset-limit 쿼리를 통해 조회하고 있는 상황입니다.
이렇게 될 경우, offset이 증가함에 따라 조회 성능이 떨어지는 단점이 있습니다. (조회하는 데이터가 많을 수록 급격히 떨어집니다.)

성능 개선 전

image

image

성능 개선 후

image

image

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants