3 ms·
Btw ws4sqlite rewrite in rust that's allegedly faster: https://github.com/proofrock/sqliterg https://github.com/proofrock/sqliterg
by geenat 3y ago
Btw ws4sqlite rewrite in rust that's allegedly faster: https://github.com/proofrock/sqliterg https://github.com/proofrock/sqliterg
- geenat 3y agoRan the same test, same server (Ubuntu 22.04 + 32 thread 7950X + Gen 4 NVME + 64GB DDR5) -- nearly zero difference sqliterg vs ws4sqlite. sqliterg (CURL) 20,000 / 2,500 / 237 For those wondering about write performance...its poor except for direct SQLite. If you're write heavy, look elsewhere, or use SQLite directly (preferably with multiple databases and WAL2). INSERT INTO users (id) VALUES (..); per second ( 1x / 10x / 100x ) SQLite WAL 11,000 / 3,000 / 300 SQLite WAL2 14,500 / 3,000 / 760 SQLite WAL2 (3x Database files) 29,000 / 6,000 / 1,400 sqliterg (CURL) 1,750 / 181 / blocks indefinitely