MATLAB: MATLAB performance on Xeon E5-2643 v4 Processor

i7intelperformanceprocessorxeon

Greeting,
I am looking to upgrade my desktop, and I have some questions to help me buy my new system. I am going to pick 256 SSD and 32 GB of RAM.
My problem with my machine is that sometimes I have to read 1000 Excel files that takes a while, and If I have a code with more than 10,000 lines, it freezes a lot when I edit. Thus, I want to upgrade my PC. Also, if you have suggestion, please let me know.
1. will MATLAB preform better on Xeon E5-2643 v4 (10MB Cache, 3.4GHz) Processor than on 6th Generation Intel® Core™ i7-6700K Processors (4.00GHz 2133MHz 8MB)?
2. can MATLAB work with two processors?
3. if I have to choose between the speed of the CPU and the size of the cache, which on would I pick? pick on of the following
Intel Xeon E5-2640 v4 Processor (25MB Cache, 2.4GHz)
Intel Xeon E5-2643 v4 Processor (10MB Cache, 3.4GHz)
Thank you

Best Answer

It appear to depend a lot on exactly what you are doing. See
One thing to pay attention to is the number of cores, which is 6 for the Xeon and 4 for that i7. For some numeric operations on large matrices, MATLAB will automatically use all available cores, so the Xeon would have the advantage. But for operations on one core (anything that cannot be automatically parallelized) that i7 is close to 1/3 faster.