|
|
|
|
|
by jarym
16 days ago
|
|
I concur. I had Claude try it out on a project I'm working on: Headline so far (nested, 10k, p50/p95/p99 µs):
┌─────────────────────┬─────────────┬────────────────┐
│ op │ SQLite │ SurrealKV │
├─────────────────────┼─────────────┼────────────────┤
│ getattr │ 1.1/1.4/1.5 │ 65/92/120 │
├─────────────────────┼─────────────┼────────────────┤
│ lookup │ 1.4/1.5/1.8 │ 73/102/138 │
├─────────────────────┼─────────────┼────────────────┤
│ readdir_page │ 45/51/59 │ 1458/1678/1843 │
├─────────────────────┼─────────────┼────────────────┤
│ create_child │ 34/55/74 │ 190/272/339 │
├─────────────────────┼─────────────┼────────────────┤
│ record_write │ 8/14/19 │ 124/157/183 │
├─────────────────────┼─────────────┼────────────────┤
│ apply_remote_object │ 9/12/17 │ 137/172/206 │
└─────────────────────┴─────────────┴────────────────┘
SQLite is ~15–60× faster on every op — and SurrealKV's reads are properly indexed, so this isn't a setup artifact.
|
|