The default built-in storage engine is a log-structured merge database. It is very fast, faster than LevelDB, supports nested transactions, and stores all content in a single disk file.
How much faster, or faster for what they don’t say.
So this brings the speed demons to three:
- LevelDB, a log-structured merge database
- SQLite4, with the default storage-engine which is a log-structured merge database too
- TokuDB, a fractal tree database
It will of course be exciting to see how fast they actually are on realistic workloads.
Wouldn’t it be nice if all three were storage engines for SQLite4? Allowing for a good comparison to be made.
Tokutek have a simple key-value store engine that seems to be close to a 1:1 match for slotting into SQLite4.
What’s exciting you the storage engine front?
↓ click the "share" button below!