I do agree it is somewhat fishy of the large performance difference not being explained by comparatively fundamentally poor data access patterns. However, Redi

I do agree it is somewhat fishy of the large performance difference not being explained by comparatively fundamentally poor data access patterns. However, Redis runs as an out of process server with marshaling and unmarshaling of data across sockets. SQLite is in process and with a prepared query is basically one library call to a purpose built data access VM. So I’m not sure why it would be hard to believe this cache and TLB friendly setup can beat Redis.