[QGIS-Developer] Geopackage slow when metadata shows generic geometries

Rahkonen Jukka (MML) jukka.rahkonen at maanmittauslaitos.fi
Fri Oct 11 08:59:47 PDT 2019


Have a look at this question https://gis.stackexchange.com/questions/338478/reading-geopackage-with-large-features-is-very-slow

I guess that quite few QGIS users know that such GeoPackages could be made to open much faster. Perhaps QGIS could give a warning and suggest to update the database to use narrow geometry type in gpkg_geometry_columns if geometry_type_name is GEOMETRY but table contains only points, linestrings/multilinestrings, or polygons/multipolygons.

How to update is another question. I noticed that gpkg_geometry_columns table does not have contraints to prevent harmful updates like changing geometry_type_name from POINT into POLYGON. Making a new database as demonstrated in gis.stackexchange would be safe but slow.

-Jukka Rahkonen-
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20191011/a1659361/attachment.html>

More information about the QGIS-Developer mailing list