Given 4D's default/primary single thread nature, a high speed single thread performance is important. The current leaders of this segment are processors released this year: Intel Xeon E Six-Core: E-2186G, E-2176G, E-2146G, and E-2136.
https://www.anandtech.com/show/13526/intel-xeon-e-review-e2186g-and-more-tested/13 https://www.cpubenchmark.net/singleThread.html Multi thread performance is not lacking on these either. https://www.cpubenchmark.net/high_end_cpus.html These all do ECC RAM, use Intel PRO, etc. which are optimal for servers Rather than a SATA SSD RAID, a mirrored pair of PCI NVME SSDs is many times faster, because it is not limited to SATA speeds. This is a comparison of NVME and SATA: https://www.anandtech.com/show/12136/the-intel-optane-ssd-900p-480gb-review/5 The above link is a year old review, a newer, faster version is available now. There is an enterprise version if you want the comfort it provides. Reading is the majority of DB activity. The biggest advantage of the Intel Octane is it excels with low queue depth reads at almost 10 times faster. You are at an optimal time to be buying hardware. -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************
