[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
branch master updated: sql: Add a couple of indexes.
From: |
Christopher Baines |
Subject: |
branch master updated: sql: Add a couple of indexes. |
Date: |
Sat, 13 Jun 2020 11:03:15 -0400 |
This is an automated email from the git hooks/post-receive script.
cbaines pushed a commit to branch master
in repository guix-cuirass.
The following commit(s) were added to refs/heads/master by this push:
new 7f71d9b sql: Add a couple of indexes.
7f71d9b is described below
commit 7f71d9b7ce33ffbe7102061a11ebb78d47c315b4
Author: Christopher Baines <mail@cbaines.net>
AuthorDate: Tue Jun 9 21:46:49 2020 +0100
sql: Add a couple of indexes.
Remove the Builds_index from the schema, as it would have been removed in
error by the upgrade-6 upgrade. Add a specific index on the Builds status
field, as this helps with db-get-builds queries, and add an index on the
Outputs derivation field, as this helps with the db-get-outputs part of
db-get-builds.
* src/sql/upgrade-8.sql: New file.
* src/schema.sql: Update accordingly.
---
src/schema.sql | 3 ++-
src/sql/upgrade-8.sql | 7 +++++++
2 files changed, 9 insertions(+), 1 deletion(-)
diff --git a/src/schema.sql b/src/schema.sql
index 8ae0a85..5ea1ff7 100644
--- a/src/schema.sql
+++ b/src/schema.sql
@@ -85,7 +85,8 @@ CREATE TABLE Events (
-- Create indexes to speed up common queries, in particular those
-- corresponding to /api/latestbuilds and /api/queue HTTP requests.
-CREATE INDEX Builds_index ON Builds(job_name, system, status ASC, timestamp
ASC, derivation, evaluation, stoptime DESC);
+CREATE INDEX Builds_status_index ON Builds (status);
+CREATE INDEX Outputs_derivation_index ON Outputs (derivation);
CREATE INDEX Inputs_index ON Inputs(specification, name, branch);
COMMIT;
diff --git a/src/sql/upgrade-8.sql b/src/sql/upgrade-8.sql
new file mode 100644
index 0000000..1be3470
--- /dev/null
+++ b/src/sql/upgrade-8.sql
@@ -0,0 +1,7 @@
+BEGIN TRANSACTION;
+
+CREATE INDEX Builds_status_index ON Builds (status);
+
+CREATE INDEX Outputs_derivation_index ON Outputs (derivation);
+
+COMMIT;
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- branch master updated: sql: Add a couple of indexes.,
Christopher Baines <=