From 238f856e48ee333ed3e19fa32ce5e1742c650c67 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Ludovic=20Court=C3=A8s?= Date: Tue, 10 Apr 2018 17:21:06 +0200 Subject: database: Adjust index to speed up /api/queue queries. * src/schema.sql: Extend 'Builds_Derivations_index' to account for /api/queue queries. --- src/schema.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/src/schema.sql b/src/schema.sql index 8d3a651..65aebbd 100644 --- a/src/schema.sql +++ b/src/schema.sql @@ -61,8 +61,8 @@ CREATE TABLE Builds ( ); -- Create indexes to speed up common queries, in particular those --- corresponding to /api/latestbuilds HTTP requests. -CREATE INDEX Builds_Derivations_index ON Builds(status ASC, derivation, evaluation, stoptime DESC); +-- corresponding to /api/latestbuilds and /api/queue HTTP requests. +CREATE INDEX Builds_Derivations_index ON Builds(status ASC, timestamp ASC, id, derivation, evaluation, stoptime DESC); CREATE INDEX Specifications_index ON Specifications(repo_name, branch); CREATE INDEX Derivations_index ON Derivations(derivation, evaluation, job_name, system); -- cgit v1.2.3