Mercurial > gemma
diff schema/gemma.sql @ 4187:65a5501dc13d
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 | d3fb2f37380b |
| children | 27ed6f709195 |
line wrap: on
line diff
--- a/schema/gemma.sql Wed Aug 07 10:23:01 2019 +0200 +++ b/schema/gemma.sql Wed Aug 07 10:27:11 2019 +0200 @@ -864,8 +864,7 @@ kind log_type NOT NULL DEFAULT 'info', msg TEXT NOT NULL ) - - CREATE INDEX kind_idx ON import_logs(kind) + CREATE INDEX import_logs_import_id ON import.import_logs (import_id) CREATE TABLE track_imports ( import_id int NOT NULL REFERENCES imports(id)