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() |