3 ms·
Disabling synchronous is dangerous and I don't know where it could be used practically (if you care about your data https://www.sqlite.org/howtocorrupt.html#_fa
by mythrwy 9y ago
Disabling synchronous is dangerous and I don't know where it could be used practically (if you care about your data https://www.sqlite.org/howtocorrupt.html#_failure_to_sync https://www.sqlite.org/howtocorrupt.html#_failure_to_sync).
That being said 'journal_mode=wal' is a bit faster than normal async but nowhere even close to the speed of disabling async completely.
- justinclift 9y ago> ... don't know where it could be used practically. Maybe with read only databases?
- mythrwy 9y agoWould you get a speed increase in reads? I thought async and wal speedup would just be for writes (no good for read only database). Maybe I'm misinformed. Have to play with it and see.
- justinclift 9y agoHmmm, I'm not sure either. If you got around to testing it, it'd be interesting to hear about. :)