[Qgis-developer] Geopackage, poor performance with large vector files

[Mats Högström]

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