News for hackers. Stuff that matters.
Re:Performance/Avoid SQLite in Your Next Firefox Feature (2014) by liuliu on Sunday June 14, 2020 @03:56PM (#23520803)
WAL mode can help large part of the fsync issues, but it does break the "one file" niceties SQLite has. If you don't care about losing some recent commits, WAL is definitely the way to go: https://www.sqlite.org/wal.html

I would also say that WAL has been receiving improvements from what I can see. For example, 3 years ago, you cannot open a WAL mode SQLite file in read-only mode, but now you can since 3.22.0.

There are no comments on this comment yet.