[Qgis-developer] Geospackage Slow in QGIS
even.rouault at mines-paris.org
Sat May 17 03:48:57 PDT 2014
Le samedi 17 mai 2014 10:46:39, Stefan Keller a écrit :
> So it's this code fragment?
> 419 /* Requirement 6: The SQLite PRAGMA integrity_check SQL command
> SHALL return â??okâ? */
> 420 /* http://opengis.github.io/geopackage/#_file_integrity */
> 421 if( strncmp(pszFilename, "/vsicurl/", strlen("/vsicurl/")) != 0 &&
> 422 OGRERR_NONE != PragmaCheck("integrity_check", "ok", 1) )
> Looks strange to me why a single file check woold be the bottlenet since
> this should be a single call.
> I would have expected that some repeated calls (like reading
> objects/records and checking SRID or data types) would be the bottleneck
> since SQlite is not performant when used with PRAGMA checks. This would be
> a check one could disable with a parameter.
I've just noticed that thread. Actually I found that integrity_check was slow
when operating on remote databases with /vsicurl/ and didn't verify how slow
it could be with local big files, but its documentation at
http://www.sqlite.org/pragma.html#pragma_integrity_check suggests that it
might be bery slow indeed.
Reading the GeoPackage spec, nothing mandates to do the integrity_check at
open time. It only mandates that if you run "pragma integrity_check" it should
retrun OK. So I've disabled the check by default.
Geospatial professional services
More information about the Qgis-developer