Mercurial > gemma

diff schema/gemma.sql @ 5122:0b6b62d247e8 queued-stage-done

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Prioritize review jobs on selection This reverts rev. 37784b70eea3 and instead moves review jobs forward in the queue when fetching the next job to be run. Also optimized index setup for filtering by state but not enqueued.
author Tom Gottfried <tom@intevation.de>
date Thu, 26 Mar 2020 14:41:23 +0100
parents f64ff954ee31
children 882b3d2308c4
line wrap: on
line diff
--- a/schema/gemma.sql	Thu Mar 26 13:53:05 2020 +0100
+++ b/schema/gemma.sql	Thu Mar 26 14:41:23 2020 +0100
@@ -1267,8 +1267,10 @@
         data       TEXT,
         summary    TEXT
     )
-
-    CREATE INDEX enqueued_idx ON imports(enqueued, state)
+    -- Mainly for listing imports in clients:
+    CREATE INDEX enqueued_idx ON imports(enqueued)
+    -- For fast retrieval of queued imports by the import queue in backend:
+    CREATE INDEX state_idx ON imports(state)
 
     CREATE TABLE import_logs (
         import_id int NOT NULL REFERENCES imports(id)