Mercurial > evolve
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 (?,?,?);"