undefined | Better HN

0 pointseasytiger13y ago0 comments

Your point eludes me? For a start that is not tuning it. It is still using synchronous IO

0 comments

4 comments · 2 top-level

snaky13y ago· 2 in thread

Search for 'write_sync'

Ahh yea i missed, apologies

     std::string sync_stmt = (write_sync) ? "PRAGMA synchronous = FULL" :
                                           "PRAGMA  synchronous = OFF";

Still. how is it a valid compare if it is getting it to ssd/hdd and the others are writing to memory? Just open sqlite3 with :memory:

You're still not understanding. LMDB is a disk-based database. It is not only writing to memory.

Note that the LevelDB, Kyoto Cabinet, and SQLite3 configs are identical to what the Google LevelDB authors used in their original benchmark. http://leveldb.googlecode.com/svn/trunk/doc/benchmark.html

The only thing different about the Symas LMDB tests is that LMDB and BDB were added.

j / k navigate · click thread line to collapse