> And LMDB beats the crap out of SQLite, in any mode. http://www.lmdb.tech/bench/microbench/ http://www.lmdb.tech/bench/microbench/ Alright, I went through thi

> And LMDB beats the crap out of SQLite, in any mode. http://www.lmdb.tech/bench/microbench/ http://www.lmdb.tech/bench/microbench/ Alright, I went through this page to see why my experience is different. While it mentions that they enabled SQLite's WAL journal, it also mentions that the synchronous writes were performed with PRAGMA synchronous=FULL. I believe that if they set PRAGMA synchronous=NORMAL, they will get an ACI-reliable database that is way faster than LMDB with write-to-disk workloads. Most of the measurements on that page are not really useful to me; they do not persist the data (db on tmpfs) or they do not care about reliability, using dangerous settings. Only few measurements are both persisting the data and writing safely, but the SQLite configuration is sub-optimal for them.