comparison schema/std_login_roles.sql @ 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 35acb7f9ae0c
children 5e38667f740c
comparison
equal deleted inserted replaced
2986:7ee9a3ef90d4 2987:524f1382558a