10000 GITC-192: Optimises generate_leaderboard to use a GROUP BY... SUM query by gdixon · Pull Request #9275 · gitcoinco/web · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content

GITC-192: Optimises generate_leaderboard to use a GROUP BY... SUM query #9275

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

Merged
merged 2 commits into from
Jul 8, 2021

Conversation

gdixon
Copy link
Contributor
@gdixon gdixon commented Jul 8, 2021
Description

This PR optimises generate_leaderboard to use a GROUP BY... SUM query to find the quest leaders up to the max_entries

Refers/Fixes

Fixes: GITC-192

Testing

Tested with production data

< 8000 div data-view-component="true" class="TimelineItem TimelineItem--condensed">
@gdixon gdixon force-pushed the GITC-192--optimise-query branch from ea40f8c to 1931def Compare July 8, 2021 06:02
@thelostone-mc thelostone-mc merged commit 1156456 into stable Jul 8, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging this pull request may close these issues.

2 participants
0