[gdal-dev] "OGR_SQLITE_SYNCHRONOUS" and "OGR_SQLITE_CACHE" accessible through Python bindings?

jratike80 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.

-Jukka Rahkonen-

Met Bas wrote
> Write speeds to GeoPackages appear to be going extremely slow in my use
> case.
> 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
> drive
> 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
> the
> script being run) through Python?
> Thank you,
> M.B
> --
> Sent from: http://osgeo-org.1560.x6.nabble.com/GDAL-Dev-f3742093.html
> _______________________________________________
> gdal-dev mailing list

> gdal-dev at .osgeo

> https://lists.osgeo.org/mailman/listinfo/gdal-dev

Sent from: http://osgeo-org.1560.x6.nabble.com/GDAL-Dev-f3742093.html

More information about the gdal-dev mailing list