# HG changeset patch
# User Sascha L. Teichmann <sascha.teichmann@intevation.de>
# Date 1571219513 -7200
# Node ID 1d6f28e45696454d87c0f4a2960d45ececf14659
# Parent  7a93889438409e9678954a680f9c50f310725d34
morphology: Doing ST_SimplifyPreserveTopology before ST_MakeValid when storing geometries to database speeds things up ... a lot.

diff -r 7a9388943840 -r 1d6f28e45696 pkg/controllers/diff.go
--- a/pkg/controllers/diff.go	Wed Oct 16 11:07:59 2019 +0200
+++ b/pkg/controllers/diff.go	Wed Oct 16 11:51:53 2019 +0200
@@ -85,10 +85,13 @@
   ST_Transform(
     ST_Multi(
       ST_CollectionExtract(
-        ST_SimplifyPreserveTopology(
-          ST_Multi(ST_Collectionextract(
-            ST_MakeValid(ST_GeomFromWKB($4, $3::integer)), 3)),
-          $5
+        ST_MakeValid(
+          ST_Multi(
+             ST_Collectionextract(
+                ST_SimplifyPreserveTopology(ST_GeomFromWKB($4, $3::integer), $5),
+                3
+             )
+            )
         ),
         3
       )
diff -r 7a9388943840 -r 1d6f28e45696 pkg/imports/sr.go
--- a/pkg/imports/sr.go	Wed Oct 16 11:07:59 2019 +0200
+++ b/pkg/imports/sr.go	Wed Oct 16 11:51:53 2019 +0200
@@ -175,10 +175,13 @@
   ST_Transform(
     ST_Multi(
       ST_CollectionExtract(
-        ST_SimplifyPreserveTopology(
-          ST_Multi(ST_Collectionextract(
-            ST_MakeValid(ST_GeomFromWKB($4, $3::integer)), 3)),
-          $5
+        ST_MakeValid(
+          ST_Multi(
+             ST_Collectionextract(
+                ST_SimplifyPreserveTopology(ST_GeomFromWKB($4, $3::integer), $5),
+                3
+             )
+            )
         ),
         3
       )