The core process of the company is running on a 4 year old server, and at this point the I.T. Staff got the budget to buy a new server. The core process is a web app with intensive writing/reading from a poorly structured MySQL database, that's why we need a good match between a powerful processor and an excellent drive to keep the process running until the database is remodeled.
We got two offers one from a DELL retailer and another from HP.
- DELL PowerEdge T630 Server ($5196 USD):
Intel Xeon E5-2650 v4 x1 2.2GHz 30M Cache (12 Cores) - RAM 16x2 GB RDIMM - 800GB Solid State Drive SATA Mix Use MLC 6Gbps 2.5in Hot-plug Drive
- HPE ProLiant DL180 Gen9 ($4692 USD):
Intel Xeon E5-2620 v4 x2 2.1GHz 20M Cache (8 Cores Each) - RAM 16x2 GB RDIMM - 240GB Solid State Drive SATA RI-2 LFF SCC SSD - 1TB HP HDD 6G SATA 3,5" 7,2K SC MDL
As you can see, the HP brings two processors, but it is relatively low in price, which gives me confusion.
Taking into account that the fact that this database is poorly structured, implies that it is necessary to resolve queries as fast as possible (speed per core) and also many queries simultaneously (number of cores); which one would you recommend?. Thanks in advance.