changeset 3356:24b72cbc486f

stablerange: add an sql index on subranges id too This should speed up query that find super ranges.
author Pierre-Yves David <pierre-yves.david@octobus.net>
date Thu, 21 Dec 2017 04:29:02 +0100
parents c261eece1eab
children 6020f2c9dbd9
files hgext3rd/evolve/stablerangecache.py
diffstat 1 files changed, 1 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- a/hgext3rd/evolve/stablerangecache.py	Thu Dec 21 04:14:05 2017 +0100
+++ b/hgext3rd/evolve/stablerangecache.py	Thu Dec 21 04:29:02 2017 +0100
@@ -94,6 +94,7 @@
                               FOREIGN KEY (subrev, subidx) REFERENCES range(rev, idx)
     );""",
     "CREATE INDEX subranges_index ON subranges (suprev, supidx);",
+    "CREATE INDEX superranges_index ON subranges (subrev, subidx);",
     "CREATE INDEX range_index ON range (rev, idx);",
 ]
 _newmeta = "INSERT INTO meta (schemaversion, tiprev, tipnode) VALUES (?,?,?);"