jimis

6 ms·

1. 31.▲
   by jimis 8y ago

   > And LMDB beats the crap out of SQLite, in any mode. 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&#
2. 32.▲
   by jimis 8y ago

   It's not that simple. What you mean by saying "(a)synchronous mode" is very different from database to database. See my above comment. Is SQLite synchronous or asynchronous if you configure it as journal_mode=WAL and PRAGMA s
3. 33.▲
   by jimis 8y ago

   If you are using MDB_NOSYNC in production, keep in mind that the trade-off for the boost in performance is that a system crash can lead to an unreadable database.
4. 34.▲
   by jimis 8y ago

   The page writes that LMDB "is exceptionally fast for our kinds of load", and then links to an in-memory microbenchmark: http://www.lmdb.tech/bench/inmem/ Aren't they interested in persistence of the