search

roam-qgis / Roam

Simple data collection built using QGIS.
http://roam-docs.readthedocs.org/en/latest/
GNU General Public License v2.0
171 stars 61 forks source link

Wal mode #362

Open rjwillson opened 7 years ago

rjwillson commented 7 years ago

I just found a way to turn off disable Write Ahead Logging (WAL) mode with SpatiaLite/sqlite and GeoPackage files when using QGIS

But when Roam opens the QGIS project I see that it turns wal on and now I can see that Roam re-enables the wal mode as shown in the screen clip below

Two questions: (1) does the wal mode improve performance in Roam when collected data into SpatiaLite and GeoPackage files; and (2) depending on answer to question 1 is it possible to somehow disable it if performance gain is happens to be minimal?

I have set Roam up to work with Dropbox and all the additional -wal and -shm files confuse the end users when they all start syncing and sometimes creating conflicted copies

image

NathanW2 commented 6 years ago

@rjwillson yeah I'm not 100% sure why I added this I suspect it was to fix something that doesn't happen anymore. I'm happy to get a pull request to remove or at least disable it for now.