3 ms·
Using SSD is kinda "throw more hardware at the problem so that we don't need to fix our precious crappy software" type of solution.
by zokier 15y ago
Using SSD is kinda "throw more hardware at the problem so that we don't need to fix our precious crappy software" type of solution.
- dmk23 15y agoThe only thing that really matters is overall system performance, which means software / hardware combination. It is hard to see the benefit of ignoring SSD to get high I/O performance vs. redesigning the software around I/O bottlenecks. Redesigning software to work on bad hardware is definitely a challenging project, but not always the best use of resources.
- lwat 15y agoNothing wrong with throwing hardware at a problem like this. In most cases it's much less painful than changing to a new RDBMS.
- rickmb 15y agoAlthough abhorred by software makers such as most HN-readers, throwing hardware at the problem is often the fastest and cheapest way to tackle performance issues. Especially when it indeed is "crappy software" that will take major effort to rewrite/refactor. Hardware is cheaper than developers, and the former doesn't fail to deliver half as often as the latter...
- deleted 15y ago[deleted]
- fauigerzigerk 15y agoThe problem with this principle is that adding hardware tends to scale linearily at best whereas improving an algorithm sometimes buys you an orders of magnitude improvement. Also, you need to compare the cost of a single developer who fixes innodb to the cost of hardware incurred by _all_ users of innodb who would benefit from the solution.
- dmk23 15y agoAdding SSD is not linear scaling. SSD has entirely different characteristics from rotational drives which in itself brings 1-3 orders of magnitude I/O performance improvement. Trying to fit high I/O workloads on spinning disks is a lot like spending your efforts to make your program run on 64K RAM. An interesting challenge, that would surely exercise your coding skills, but would not deliver the optimal performance.
- fauigerzigerk 15y agoI'm not denying the benefits of SSD. I just don't think throwing hardware at a problem caused by bad algorithms is a good general principle. It may still be the best choice in a particular situation and timeframe.