When using an external db every query needs to cross the connection boundary and thus perform network IO and deal with the threading implications for that IO. W

When using an external db every query needs to cross the connection boundary and thus perform network IO and deal with the threading implications for that IO. With SQLite running in-process a round trip just means a function call, and when data is available in the cache it won’t even hit the disk.