Mercurial > gemma
comparison 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 |
comparison
equal
deleted
inserted
replaced
2125:ea5a0e771b71 | 2126:d4a5e475f874 |
---|---|
234 | 234 |
235 if _, err := tx.ExecContext(ctx, createGeomTempTableSQL); err != nil { | 235 if _, err := tx.ExecContext(ctx, createGeomTempTableSQL); err != nil { |
236 return err | 236 return err |
237 } | 237 } |
238 | 238 |
239 if _, err := tx.ExecContext(ctx, createTempIndexSQL); err != nil { | |
240 return err | |
241 } | |
242 | |
239 insertStmt, err := tx.PrepareContext(ctx, insertGeomTmpTableSQL) | 243 insertStmt, err := tx.PrepareContext(ctx, insertGeomTmpTableSQL) |
240 if err != nil { | 244 if err != nil { |
241 return err | 245 return err |
242 } | 246 } |
243 defer insertStmt.Close() | 247 defer insertStmt.Close() |