3 ms·
You're reaching. Modern filesystems cache disk access in memory, and modern hardware doesn't use spinny disks for applications.
by Cthulhu_ 3y ago
You're reaching. Modern filesystems cache disk access in memory, and modern hardware doesn't use spinny disks for applications.
- yawaramin 3y agoAlso, SQLite has a configurable local page cache which it maintains directly in your application's process. There's a very likelihood that you're just hitting that in-memory cache directly, let me emphasize, in your own process. In-process memory cache hit is faster than separate-process memory cache hit over ethernet.
- bravetraveler 3y agoWe're actually to a point where storage bandwidth can exceed memory! NVMe arrays are weird, can be better to just rip it from the drives if you need bandwidth over latency Even then, with how easy the memory cache is to invalidate... I'm not sure even that's worthwhile. The caching isn't some Paragon of performance - there's only so much it can do, when looking at it funny invalidates it.