SQLite3 ported to use LMDB instead of its original Btree code
3 months ago
- #Performance
- #LMDB
- #SQLite
- SQLite3 has been ported to use LMDB instead of its original Btree code.
- To set the LMDB mapsize in pages, use: PRAGMA max_page_count=<integer>.
- Performance test results show significant speed improvements with LMDB.
- Inserting 1000 records took 22.42 seconds with original code vs. 1.06 seconds with LMDB.
- Recent tests (version 3.7.17) show LMDB outperforming SQLite in various operations.
- LMDB excels in read operations, with Seq Read and Rev Seq Read showing notable improvements.