Hello,
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 or Intel Xeon E3-1275 V2. 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?).
I might setup 4 virtual machines each to run a separate image of the EXCEL+MATLAB+PIPELINE……I wonder which PC you would recommend for such a setup?
Please let me know what you think,
Dave
Recommend Pc Setup for Large-Scale Excel Number Crunching Project
-
-
-
Re: Recommend Pc Setup for Large-Scale Excel Number Crunching Project
I wonder if any one with i7 3930K or XEON E3 127V2 can comment on the multi-threading boost to EXCEL 2010 or EXCEL 2007 performance???? I need this to make the final decision between these two setups...do you think the multi-threaded EXCEL 2010 in the case of i7 3930K or XEON E3 127V2 can be significantly faster than the single threaded EXCEL 2003?
thanks a lot!) -
Re: Recommend Pc Setup for Large-Scale Excel Number Crunching Project
Well, I don't own an i7 "whatever", but . . .
The question is, essentially, a moot one: Excel 2010 provides so many more usefule features and new functions that it is hands-down, IMO, the right choice.
Pivot Table Slicers in 2010 are a tremendously useful feature, especially if you will be building a dashboard.As for the multi-threading boost - see this.
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!