Mercurial > gemma
changeset 2126:d4a5e475f874
Actually create index on temp table
Makes import of waterway profiles roughly four times faster.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Wed, 06 Feb 2019 14:27:14 +0100 |
parents | ea5a0e771b71 |
children | a1f2cfa624cf |
files | pkg/imports/wp.go |
diffstat | 1 files changed, 4 insertions(+), 0 deletions(-) [+] |
line wrap: on
line diff
--- a/pkg/imports/wp.go Wed Feb 06 11:47:02 2019 +0100 +++ b/pkg/imports/wp.go Wed Feb 06 14:27:14 2019 +0100 @@ -236,6 +236,10 @@ return err } + if _, err := tx.ExecContext(ctx, createTempIndexSQL); err != nil { + return err + } + insertStmt, err := tx.PrepareContext(ctx, insertGeomTmpTableSQL) if err != nil { return err