[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[no subject]

From: Ludovic Courtès
Date: Tue, 10 Apr 2018 11:25:49 -0400 (EDT)

branch: master
commit 238f856e48ee333ed3e19fa32ce5e1742c650c67
Author: Ludovic Courtès <address@hidden>
Date:   Tue Apr 10 17:21:06 2018 +0200

    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);

reply via email to

[Prev in Thread] Current Thread [Next in Thread]