4 ms·
I would gladly pay 100k+ for a single 10ghz processor with comparable bus speed / RAM combo. Got a single threaded legacy DB that runs way too many things for a
by chime 6y ago
I would gladly pay 100k+ for a single 10ghz processor with comparable bus speed / RAM combo. Got a single threaded legacy DB that runs way too many things for a large company. Upgrading to a new system is going to cost million+. Running liquid cooled 5hz CPU on a gaming rig right now with an identical box on standby in case of H/W issues. Could easily justify spending 200k every year if it doubled the DB performance.
- DaiPlusPlus 6y agoWouldn’t it cost less than $100k to fix the project to use any commodity SQL database (presumably over ODBC)? Or are we talking about an unsalvageable 4GL system that had its last update 15 years ago that does everything (storage engine, OLTP, forms UI framework, security, and reports)?
- chime 6y agoClose. Running 2009 version of a commercial DB that does everything with no cheap upgrade path.
- DaiPlusPlus 6y agoIt’s Progress or FoxPro, right?
- ksec 6y agoThis. In terms of Single Core / Thread Performance we have reached the end of S curve. We haven't had much IPC improvements since Skylake in 2014. We reached the Max Clock speed per normal Cooling possibilities. Although current rumours suggest 7nm Ocean Cove coming in 2022 with 85% increase of IPC compared to Skylake. I wish we could also make performance node that push through 6Ghz.
- willis936 6y agoWho would possibly believe that 85% IPC increase is on the table for silicon without a wafer sized die?
- noir_lord 6y agoNo-one but (hypothetically) Intel putting a rumour out like that might make people thinking of switching to AMD to hold-off and see. If I was been cynical.
- ksec 6y agoWell there is 25% from Willow Cove to Skylake, so you are looking at 20% increase from Willow Cove to Golden Cove, and another 20% from Golden Cove to Ocean Cove. Not entirely impossible. Given some of these improvement has been sitting within Intel for years due to the delay in 10nm.
- noir_lord 6y agoNot impossible, we are a long way from computronium but I'll believe it when I see it in independent benchmarks.
- Veedrac 6y agoApple already has an ~80% IPC lead over Intel. So, me.
- willis936 6y agoGonna need some heavy sources on that one. I can make an ALU in an FPGA that only takes in one bit data and adds it. That would take the IPC crown. Is it a useful statement? No. Comparing ARM IPC to x86 IPC is far more complicated than measuring length.
- Veedrac 6y agoSee SPECint2006 in [1] (ctrl-f “absolute performance”). SPECfp is maybe more like a 60% IPC lead, but less relevant to typical users. I've taken some measurements of the A13's microarchitecture (mostly, its ROB size), and Apple has a bigger lead here than you'd expect. I don't want to share his data without permission, but the bulk of the code is at [2] and I'd be happy to help anyone able to run code on an iDevice repeat the same measurements. [1] https://www.anandtech.com/show/14892/the-apple-iphone-11-pro-and-max-review/4 https://www.anandtech.com/show/14892/the-apple-iphone-11-pro... [2] https://github.com/Veedrac/microarchitecturometer https://github.com/Veedrac/microarchitecturometer
- jiggawatts 6y agoYou 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?
- richthegeek 6y agoThis raises quite a few interesting questions and tradeoffs - how do you handle ugprades (i.e. yearly upgrade to latest/fastest CPU) without taking down the standby box? Have 3 boxes? How about instant handoff? I guess that would require running the second box as a slave, so both boxes are running harder than they need to... Does running one of the old FX-8350/70 at 7+ GHz have any benefit, or is it offset by the per-tick improvements of newer CPUs? It's weird to think of heavily overclocking stuff in a non-gaming workload for me... stuff like chilled coolant and instability suddenly has completely differnet factors to consider.
- ansgri 6y agoI'd suppose it doesn't need zero downtime outside of some well-defined business hours. Actually most of things don't and I think would even benefit from planned monthly 5hr outage instead of unplanned 10hr once per year.
- est31 6y agoHmm I wonder what the market in nitrogen cooled super-high clocked systems is. At that price range there should be something that you can do, no?