storage/sqlite/sqlite-storage.go | 2 ++ diff --git a/storage/sqlite/sqlite-storage.go b/storage/sqlite/sqlite-storage.go index 8ec4d5a6d42e6f3e48790bd5f317f5a12ff5e550..0e1edd1b9db463a454b94287e29876d43afb6bdf 100644 --- a/storage/sqlite/sqlite-storage.go +++ b/storage/sqlite/sqlite-storage.go @@ -73,6 +73,8 @@ create table if not exists blob_meta ( key text primary key, value ); + + create index if not exists blob_last_used on blob(last_used); -- While sqlite *seems* to be faster to get sum(length(data)) instead of -- sum(length(cast(data as blob))), it may still require a large table scan at start-up or with a