diff schema/demo-data/README @ 2987:524f1382558a

Make snapping of many axis segments faster Since a CTE is materialized anyhow, make the one for the UTM projected axis a temporary table, extended by the precalculated geometry boundaries and a spatial index on these, which then can be used in geometry comparisons within the recursive CTE. This makes snapping several hundreds of segments faster by more than an order of magnitude at the expense of longer runtime for snapping only very few segments, because of the additional cost for index creation. This could be further optimized by first checking if there is a direct match without any snapping, but since the function is currently only used in import processes, a runtime of a few seconds seems acceptable.
author Tom Gottfried <tom@intevation.de>
date Wed, 10 Apr 2019 10:02:07 +0200
parents 0c0826063561
children 5e38667f740c
line wrap: on
line diff