I'm debating on just using D1 with a table of key-value pairs, but I was told the latency for KV is significantly less than D1 for repeat lookups. I'm wanting to do a lookup as a part of every request, so the answer is important here, but I haven't been able to find any data. How long does it take to load a value from KV? And how long does it take to load a value from a D1 table?

I'd recommend looking at rather than having performance as the only factor, they're pretty different solutions.

I know the other differences, and none are particularly relevant to my use case. The biggest factor right now is cost, and D1 is a fraction of the cost of KV. Since I can't find a metric on latency, it really does boil down to how much am I paying for how much improved latency. At edge sounds like KV would be fastest, but I'd really like to know the SLAs or data for the latencies. 🤔

I don't think any of them have any SLAs for latencies.