[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.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the QGIS-Developer