summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorLars Wirzenius <liw@liw.fi>2021-01-04 09:47:18 +0000
committerLars Wirzenius <liw@liw.fi>2021-01-04 09:47:18 +0000
commitf73b2a919dc2fe2d92eef6df9b7cab25af083fb3 (patch)
tree2a854c2fd23904be7d9594e8192dac522546a2e4
parent17b38a9d4512304972b2572d4bbf9815cf8894c7 (diff)
parentfbaa0543caae8f00f57ddd0410acabf2272d2261 (diff)
downloadobnam2-f73b2a919dc2fe2d92eef6df9b7cab25af083fb3.tar.gz
Merge branch 'opt' into 'main'
feat: add an index for chunk ids lookups See merge request larswirzenius/obnam!57
-rw-r--r--src/generation.rs1
1 files changed, 1 insertions, 0 deletions
diff --git a/src/generation.rs b/src/generation.rs
index e225fda..b55e244 100644
--- a/src/generation.rs
+++ b/src/generation.rs
@@ -151,6 +151,7 @@ mod sql {
params![],
)?;
conn.execute("CREATE INDEX filenames ON files (filename)", params![])?;
+ conn.execute("CREATE INDEX filenos ON chunks (fileno)", params![])?;
conn.pragma_update(None, "journal_mode", &"WAL")?;
Ok(conn)
}