3 ms·
With WAL it's a generally smooth experience. Really depends on your use case though. https://sqlite.org/wal.html https://sqlite.org/wal.html
by Grimburger 5y ago
With WAL it's a generally smooth experience. Really depends on your use case though.
https://sqlite.org/wal.html https://sqlite.org/wal.html
- magicalhippo 5y agoThe WAL doesn't work with shared directories (NFS/SMB) though. Found this out when I tried to store the Plex data directory on a NSF share in a VM and it had really weird issues. Turned out Plex uses SQLite with WAL enabled.
- Grimburger 5y agoThat's point number two in the disadvantages: > WAL does not work over a network filesystem. Somewhat strange for plex to ship with that by default given how many people generally have network shares for such things.
- stavros 5y agoThat looks great, thanks. I didn't realize it wasn't on by default, but it sounds like it'll greatly benefit the web app use case, where all web workers are on the same Linux machine. Sounds like WAL is the way to go in most use cases, unless you want shared access from different machines.