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 <[email protected]>: > 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 [email protected]) 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 > [email protected] > http://lists.osgeo.org/mailman/listinfo/qgis-developer >
_______________________________________________ Qgis-developer mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-developer
