4 ms·
> I’d assume that most queries are limited by memory / disk access time That's not true for all that many analytics statements actually. Good storage systems c
by anarazel 8y ago
> I’d assume that most queries are limited by memory / disk access time
That's not true for all that many analytics statements actually. Good storage systems can deliver data quite fast, and in many cases the buffer cache can hide a lot of the access latency too.
There's obviously issues with memory access latencies, but that's actually something that JIT compilation can hide with, because it increases the amount of work that can be done in the out-of-order window. Without JIT there's just too many instructions for that to hide all that memory access latencies.