Hi, Is QGIS using the geopackage spatial index?
I have this large geopackage file with one vector layer, 16Gb 6 million polygons stored locally on my computer. When I add it to QGIS using Add Vector layer, the program becomes unresponsive for about 20 minutes until the layer appears in the Layer panel. I do this with the Render option off. When zooming in to 1:50 0000 and turning rendering on it takes about 10 minutes until the polygons start drawing on the canvas. Pan and zoom takes ages and using the Identify features tool takes 5 minutes to display the values. It's just not possible to work with the data. The original data is in an ESRI file geodatabase. I created the geopackage file with a spatial index using ogr2ogr version 2.1.2. Opening the ESRI file geodatabase in QGIS works great, performance is very good. Opening the geopackage file in ArcMap also works fine. Setup: Dell Precision 16Gb RAM 500Gb disk. Ubuntu 16.04 QGIS version 2.18.3 Compiled against Qt 4.8.7 Compiled against GDAL/OGR 1.11.3 Compiled against GEOS 3.5.0-CAPI-1.9.0 PostgreSQL Client Version 9.5.2 QWT Version 5.2.3 QScintilla2 Version 2.9.1 QGIS code revision 77b8c3d Running against Qt 4.8.7 Running against GDAL/OGR 1.11.3 Running against GEOS 3.5.0-CAPI-1.9.0 r4084 SpatiaLite Version 4.3.0a PROJ.4 Version 492 Mats Högström GIS manager SLU Swedish University of Agricultural Sciences Remote sensing department Umeå Sweden _______________________________________________ Qgis-developer mailing list Qgis-developer@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer