[Qgis-developer] Geospackage Slow in QGIS

[Martin Dobias]

Hi

On Sat, May 17, 2014 at 2:32 PM, Jeremy Palmer <JPalmer at linz.govt.nz> wrote:
> I've just been using the new implementation of Geopackage in QGIS :) However each map render or feature info is very slow for large database files - even with the new GDAL/OGR Geopackage spatial index support. Each time QGIS renders a new map view or executes a feature info it re-opens the Geopackage file in QgsOgrFeatureIterator via OGROpen, and the Geopackage driver open method runs PRAGMA integrity_check which is very slow (4 secs with my 2GB test file). This integrity check is actually a Geopackage requirement.
>
> How can this be fixed? At the in QGIS or GDAL/OGR level?

Actually I am wondering how different is the format of GeoPackage from
the format of SpatiaLite... we could use our native SpatiaLite
provider also for GeoPackage files if they are close enough. Any
ideas?

Regards
Martin