[gdal-dev] Spatialite and UPDATE triggers

[Jukka Rahkonen]

Even,

I noticed that you have worked with INSERT triggers in
http://trac.osgeo.org/gdal/changeset/27936.

What would you say about the discussion in
https://groups.google.com/forum/#!searchin/spatialite-users/
trigger/spatialite-users/A6gR--y2dr4/pkXg4nSdP2IJ

I suppose that the new generation triggers will be created automatically if
GDAL is built with the next-to-come Spatialite 4.2.1 but it may take some
time before majority of GDAL users will have it. However, new triggers
should be backward compatible for all Spatialite 4.x versions. I wonder if
it would make sense to make GDAL to do something similar than SELECT
UpgradeGeometryTriggers that is mentioned in the thread. Ten times more
speed when doing UPDATE of non-geometry attributes for each row is quite a
lot. Of coarse if Spatialite v. >=4.2.1 will be soon a standard for building
GDAL with Spatialite the unnecessary slow update trigger issue will be
solved automatically.

-Jukka Rahkonen-