This repository has been archived by the owner on Oct 10, 2024. It is now read-only.
Add time indexes to Submission
model to improve performance
#354
Labels
API
Suggestion which would change the user-facing API
Many Buttercup queries filter submissions by ranges of
create_time
,claim_time
orcomplete_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 forclaim_time
andcomplete_time
.The text was updated successfully, but these errors were encountered: