From fbaa0543caae8f00f57ddd0410acabf2272d2261 Mon Sep 17 00:00:00 2001
From: Lars Wirzenius <liw@liw.fi>
Date: Mon, 4 Jan 2021 11:32:00 +0200
Subject: feat: add an index for chunk ids lookups

---
 src/generation.rs | 1 +
 1 file changed, 1 insertion(+)

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)
     }
-- 
cgit v1.2.1