[zbentley]

There are still context switches with sqlite, even in-memory sqlite (it has to mess with files, which means syscalls). Just not network ops.

[kiitos]

In-memory SQLite doesn't read or write files, and therefore doesn't generate syscalls, by definition.

[zbentley]

Fair enough; I didn't realize that ":memory:" SQLite accesses did zero syscalls overall, I had assumed that they required shared memory writes that entailed syscalls for barriers and the like.

I'm happy you helped me learn that's not the case! That'll make several things I regularly need to do much, much easier.

[kiitos]

Sure! It's a huge and important benefit of that access mode.