Hacker News new | ask | show | jobs
by nickodell 2852 days ago
Are you really comparing the same thing, then? Do you have the same consistency guarantees if the system shuts down unexpectedly?
1 comments

When I saw the results I did not believe, so I reviewed the benchmark code. It is basically the same SQL commands being run in normal SQLite and with the branching enabled.

Yes, LMDB is proved to be safe. It is used in many apps and even other DB implementations, including Monero.

What I have not tested is SQLite with WAL (Write-Ahead Log). In this case it may be faster than the default journal mode.

Yes, it would be nice to see results with WAL, as it's significantly faster in most cases.