From 4e811c0c7fc82313ce47080bd269983c47a7cef3 Mon Sep 17 00:00:00 2001 From: Aaron Schulz Date: Tue, 3 Apr 2012 17:24:44 -0700 Subject: [PATCH] Reduced file journal index bloat by removing indexes that would only be used in rare cases and where we'd almost always only be interested in very recent entries only (timestamp is indexed). This should decrease insertion time a bit. Change-Id: Idb33ee3229315c44b764a8ed476afe8760f5595c --- maintenance/archives/patch-filejournal.sql | 2 -- 1 file changed, 2 deletions(-) diff --git a/maintenance/archives/patch-filejournal.sql b/maintenance/archives/patch-filejournal.sql index b7a7d09f7b..8c2f6b95c8 100644 --- a/maintenance/archives/patch-filejournal.sql +++ b/maintenance/archives/patch-filejournal.sql @@ -19,6 +19,4 @@ CREATE TABLE /*_*/filejournal ( ); CREATE INDEX /*i*/fj_batch_id ON /*_*/filejournal (fj_batch_uuid,fj_id); -CREATE INDEX /*i*/fj_path_id ON /*_*/filejournal (fj_path_sha1,fj_id); -CREATE INDEX /*i*/fj_new_sha1 ON /*_*/filejournal (fj_new_sha1,fj_id); CREATE INDEX /*i*/fj_timestamp ON /*_*/filejournal (fj_timestamp); -- 2.20.1