# HG changeset patch # User Tom Gottfried # Date 1549459634 -3600 # Node ID d4a5e475f8749bbcaac0d863f3e27bcfa73ab305 # Parent ea5a0e771b71753d43624621017daeab565e1433 Actually create index on temp table Makes import of waterway profiles roughly four times faster. diff -r ea5a0e771b71 -r d4a5e475f874 pkg/imports/wp.go --- 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