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

Add time indexes to Submission model to improve performance #354

Open
TimJentzsch opened this issue Feb 6, 2022 · 0 comments
Open

Add time indexes to Submission model to improve performance #354

TimJentzsch opened this issue Feb 6, 2022 · 0 comments
Labels
API Suggestion which would change the user-facing API

Comments

@TimJentzsch
Copy link
Contributor

Many Buttercup queries filter submissions by ranges of create_time, claim_time or complete_time.
In particular, the /queue command fetches submissions filtered by ranges of these dates, every 2 minutes.

We should add tree indexes for these fields to make these queries faster.
I suggest a clustered index for create_time and unclustered indexes for claim_time and complete_time.

@TimJentzsch TimJentzsch added the API Suggestion which would change the user-facing API label Feb 6, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
API Suggestion which would change the user-facing API
Projects
None yet
Development

No branches or pull requests

1 participant