[gdal-dev] "OGR_SQLITE_SYNCHRONOUS" and "OGR_SQLITE_CACHE" accessible through Python bindings?
jukka.rahkonen at maanmittauslaitos.fi
Sun May 23 00:53:10 PDT 2021
By reading https://sqlite.org/asyncvfs.html you could try if setting the
journal mode into WAL with a PRAGMA command would help.
Met Bas wrote
> Write speeds to GeoPackages appear to be going extremely slow in my use
> GPKG/SQLite journal files are being created at the sizes of 10-25 kb
> incrementally increasing the main geopackage file. This is saving on a
> where such small incremental cause larger slowdowns, so I would like to
> increase the size of these changes.
> The configuration options "OGR_SQLITE_SYNCHRONOUS" and "OGR_SQLITE_CACHE"
> appear relevant to increasing speed.
> Is there a way in which I can set these options (limited to the scope of
> script being run) through Python?
> Thank you,
> Sent from: http://osgeo-org.1560.x6.nabble.com/GDAL-Dev-f3742093.html
> gdal-dev mailing list
> gdal-dev at .osgeo
Sent from: http://osgeo-org.1560.x6.nabble.com/GDAL-Dev-f3742093.html
More information about the gdal-dev