Skip to content

Improvement to scoreboard system #14

Description

@Skaty

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?).

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions