[Qgis-developer] Geospackage Slow in QGIS

[Even Rouault]

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.

Even


-- 
Geospatial professional services
http://even.rouault.free.fr/services.html