Comment by bob1029

> simultaneously throwing away incredible CPU and PCIe performance gains

We really need to double down on this point. I worry that some developers believe they can defeat the laws of physics with clever protocols.

The amount of time it takes to round trip the network in the same datacenter is roughly 100,000 to 1,000,000 nanoseconds.

The amount of time it takes to round trip L1 cache is around half a nanosecond.

A trip down PCIe isn't much worse, relatively speaking. Maybe hundreds of nanoseconds.

Lots of assumptions and hand waving here, but L1 cache can be around 1,000,000x faster than going across the network. SIX orders of magnitude of performance are instantly sacrificed to the gods of basic physics the moment you decide to spread that SQLite instance across US-EAST-1. Sure, it might not wind up a million times slower on a relative basis, but you'll never get access to those zeroes again.