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

Improvement to scoreboard system #14

Open
Skaty opened this issue Jun 18, 2016 · 0 comments
Open

Improvement to scoreboard system #14

Skaty opened this issue Jun 18, 2016 · 0 comments
Labels

Comments

@Skaty
Copy link
Member

Skaty commented Jun 18, 2016

Currently, the scoreboard view makes all DB calls at once, which may sound nice, but it's a large GROUP BY query with multiple annotations.

This may cause a performance issue as the call is expected to retrieve every Score from the DB.

Suggestion: Use AJAX to retrieve scores for each individual game and spread out the calls such that the DB calls are spread out across a predetermined timespan (5 minutes?).

@jia1 jia1 added the bug label Sep 26, 2016
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants