[Qgis-developer] Geospackage Slow in QGIS

Stefan Keller sfkeller at gmail.com
Sat May 17 01:20:18 PDT 2014

Hi Jeremy

Is this PRAGMA integrity_check really the bottle neck?
Is it an integrity check on a data type (e.g. integer - its probably
actually an integrity check on SRID)?
Can you point to the code?

Yours, Stefan

2014-05-17 9:32 GMT+02:00 Jeremy Palmer <JPalmer at linz.govt.nz>:

> 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?
> Cheers,
> Jeremy
> This message contains information, which may be in confidence and may be
> subject to legal privilege. If you are not the intended recipient, you must
> not peruse, use, disseminate, distribute or copy this message. If you have
> received this message in error, please notify us immediately (Phone 0800
> 665 463 or info at linz.govt.nz) and destroy the original message. LINZ
> accepts no responsibility for changes to this email, or for any
> attachments, after its transmission from LINZ. Thank You.
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20140517/65a07741/attachment.html>

More information about the Qgis-developer mailing list