Mercurial > gemma

diff schema/updates/1107/01.reindex_import_logs.sql @ 4187:65a5501dc13d

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Enable faster access to import logs Import logs are accessed per import. Index accordingly and leverage index usage in respective SQL statements.
author Tom Gottfried <tom@intevation.de>
date Wed, 07 Aug 2019 10:27:11 +0200
parents
children
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/schema/updates/1107/01.reindex_import_logs.sql	Wed Aug 07 10:27:11 2019 +0200
@@ -0,0 +1,2 @@
+DROP INDEX import.kind_idx;
+CREATE INDEX import_logs_import_id ON import.import_logs (import_id);