Hi, 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-
_______________________________________________ QGIS-Developer mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
