4 ms·
What are you even talking about? Hardware reliability has gone through the roof in recent years. So has performance in some areas, such as SSDs, GPUs, displays.
by matt4077 11y ago
What are you even talking about? Hardware reliability has gone through the roof in recent years. So has performance in some areas, such as SSDs, GPUs, displays. The ability to run a medium-sized startup or a complex scientific simulation on commodity hardware is a fantastic force of democratization access.
DBs are CPU-limited and, yes, single-core performance has been stagnating. But that's unlikely to be a vast conspiracy.
- alex_anglin 11y agoDepends on the workload: Analytical DBs are often I/O limited.
- imaginenore 11y agoModern consumer SSDs are what, 2GB/sec, DDR4 is 60GB/sec. What kind of CPU can process data at these speeds?
- zardo 11y agoIsn't the cache going to be in the 100GB/s range? Why would we even have a cache if memory speed wasn't a bottleneck.
- imaginenore 11y agoThat's not the point. Even trivial meaningful data manipulations are not possible at such speeds. Maybe on some 18-core Xeons, and even then I doubt it.
- tremon 11y agoDBs are CPU-limited and, yes, single-core performance has been stagnating. What are you basing this on? Database engines are only CPU-limited only if you have unlimited I/O bandwidth. Also, database engines hardly ever have only one query to process. Even if queries were not parallellizable (which they certainly are), single-core performance has little impact on overall performance.