summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorLars Wirzenius <liw@liw.fi>2021-01-04 11:32:00 +0200
committerLars Wirzenius <liw@liw.fi>2021-01-04 11:32:00 +0200
commitfbaa0543caae8f00f57ddd0410acabf2272d2261 (patch)
tree2a854c2fd23904be7d9594e8192dac522546a2e4
parent17b38a9d4512304972b2572d4bbf9815cf8894c7 (diff)
downloadobnam2-fbaa0543caae8f00f57ddd0410acabf2272d2261.tar.gz
feat: add an index for chunk ids lookups
-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)
}