I wonder if you can help me to build the perfect PC setup for the following task:
I am going to perform daily financial market analysis on multiple instruments using Excel (large workbooks around 300 and 500 mbs), Matlab and Automation software. The price will be loaded into Excel, the results would be fed into Matlab to create charts (this sequence will be repeated many times). I plan to sell the resultant analysis at my website for a set monthly subscription – so this can be considered a production workstation. The total process would take 5-7 hours daily. I need this process to run as error-free as possible – absolutely predictably on autopilot. So I am not planning to over-clock the CPU.
I am deciding between a workstation built on Intel Core i7-3930K or the one built on single Intel Xeon E5-2630. These CPUs are roughly the same in price (same number of cores, different speed though) with the I7 being much faster one. But I am more concerned with reliability and stability of this setup. Do you think the ECC memory can help eliminate system crashes when the analysis job is running? I need to be able to connect this PC remotely to initiate the analysis jobs as well. I am also thinking of Intel Core i7-3930K which is very fast but not sure about its stability for long-duration number crunching sessions (it can overheat if run at full speed for many hours?).
Please let me know what you think,