Hi, 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 > [email protected] > https://lists.osgeo.org/mailman/listinfo/gdal-dev -- Sent from: http://osgeo-org.1560.x6.nabble.com/GDAL-Dev-f3742093.html _______________________________________________ gdal-dev mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/gdal-dev
