3 ms·
You might be able to get close to this now. A cryogenic cooling system that could let a CPU run at 7 GHz would be doable for about $100K. But more realistical
by jiggawatts 6y ago
You might be able to get close to this now.
A cryogenic cooling system that could let a CPU run at 7 GHz would be doable for about $100K.
But more realistically, there are often a long list of other things that can be done to a legacy DB that have a much bigger bang-for-buck, and are also lower risk.
Try NVMe storage. Databases love low-latency storage.
Are you virtualising this in any way? Don't.
Use a better NIC to cut down latency. Think 200 Gbps Mellanox cards with jumbo frames instead of the built-in Broadcom chip that probably cost $1.50.
Try co-locating the app(s) on the same box with the database to really cut the latency. This works great with modern many-core CPUs like an AMD EPYC. You can often dump everything onto one machine and your latency will go from 1ms to 10μs. That's a 100-fold difference!
Turn off the CPU vulnerability mitigations. This is safe as long as nothing else runs on the same hardware. Boosts some databases up to 50%.
Pin the process threads to specific CPU cores. Some newer Intel Xeons have "preferred cores" that will turbo boost higher than any other core.
Upgrade to the latest CPU to get more instructions per clock. This can have surprisingly beneficial effects.
Or... I dunno... fix the database. Does it even use indexes?