diff pkg/imports/wp.go @ 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 86c88fc0ff5e
children a1f2cfa624cf
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