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

Optimize database performance #7

Closed
ygina opened this issue Apr 20, 2018 · 1 comment
Closed

Optimize database performance #7

ygina opened this issue Apr 20, 2018 · 1 comment
Labels
api performance

Comments

@ygina
Copy link
Contributor

ygina commented Apr 20, 2018 •
edited
Loading

Indexes and google other SQL performance tips.

For example, it's probably slow to match users to teams because there are no foreign keys in array fields, which means no automatic indexing. Although it's fast to query all the submissions of a team of a certain tournament (due to indexing on foreign keys), it might be slow to get the most recent submission if there are a lot of submissions.
@joshuagruenstein
Copy link
Contributor

This seems especially important after testing API performance for Battlehack West.

@jsegaran jsegaran closed this as completed Nov 4, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
api performance
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@ygina @joshuagruenstein @jsegaran