3 ms·
Databases see order-of-magnitude slowdowns depending whether the query plan uses an index. Operating system caches result in high performance variation for disk
by skybrian 9y ago
Databases see order-of-magnitude slowdowns depending whether the query plan uses an index. Operating system caches result in high performance variation for disk I/O. Even CPU's have highly variable performance depending on branch prediction and the size of on-CPU caches. So this is nothing new; other than hard real-time programming, we already live with high performance variation.