quote RandomeA program that can use multiple threads will definitely be as many times better, as many more cores you have.
1 core used and 5 wasted is obviously a waste if you could have 6 of 6 in use. Virtual cores make little difference.
I don't have Excel, so I'm just speculating.
And as for the difficult to replace memory. If it's that important, I would buy 1 extra at some point, so I could replace it with in hours of the failure.
quote dave777CPU's are actually a lot more capable than you think, I had a i7 950 setup (Gen 1) that I ran 24/7 under full load, while overclocked to 4ghz, using folding @ home, only time it wasn't at full load was when the power went out, this was used for 2 years, until I upgraded this week. Same story with GPU's as I have had my 5830 running at constant full load 24/7 while mining bitcoins (ie. lots and lots of calculations) for over a year.I wonder if you have tried running your i73930k for long periods of time..like 10 hours at the maximum load....I wonder how it behaved? lets say for 8-10 hours in a row....at 95% (no over-clocking) - did you see any hints of instability in its performance?
quote dave777I have an i7 2600k, the earlier generation, and I've ran it at close to max load for around 5 hours with no problems (it was a high end game). I've also had this computer run for up to a week before I started getting errors. This is with the CPU underclocked though, since it is really hot where I am so I'd rather it produce less heat.I wonder if you have tried running your i73930k for long periods of time..like 10 hours at the maximum load....I wonder how it behaved? lets say for 8-10 hours in a row....at 95% (no over-clocking) - did you see any hints of instability in its performance?
quote ashantiquaharbin91 has it right.
server hardware is purpose built for what youre looking for, that is, sustained, uninterrupted, reliable operation.
ECC memory is also a bit slower than non-ECC memory, but for sustained operation, its your guy.
as for multicore performance, heres some info concerning excel 2007 to present:
"Most workbooks show a significant improvement in calculation speed on a system with multiple cores. The degree of improvement depends on how many independent calculation trees the workbook contains. If you make a workbook that contains one continuous chain of formulas, it will not show any multithreaded calculation (MTC) performance gain, whereas a workbook that contains several independent chains of formulas will show gains close to the number of processors available."
"Results showed calculation times ranging from no improvement to better than theoretical (2x/4x) improvement on both the dual-core and quad-core systems. Typical (median) improvement for a system with an Intel dual-core Pentium 4 at 3.0 GHz with 1 GB of RAM compared to the same file calculating in Excel 2003 was 48 percent, or a 1.92x speedup. Typical (median) speedup for a system with an Intel quad-core Xeon at 3.0 GHz with 4 GB of RAM was 76 percent, or a 4.17x speedup. Similar speed improvements were observed on other processors and platforms. Improvements beyond theoretical speedup (because of multithreading) are attributed to other performance improvements starting in Excel 2007, such as improvements to the speed of function execution."
looks like if the type of calculation youre doing is supported with multicore processing, youll get great performance gains. its scalable, so the more cores you have, the better performance you should see.
some forms of calculating are not supported by multithreading / multicores however.
"Some Excel features do not use multithreaded calculation. For example:
Data table calculation (however, structured references to tables do use MTC).
User-defined functions (however, XLL functions can be multithread-enabled).
INDIRECT, CELL functions that use either the format2 or address options.
GETPIVOTDATA and other functions referring to PivotTables or cubes.
Range.Calculate and Range.CalculateRowMajorOrder.
Cells in circular reference loops."
Powered by neoforums v2.3.9b (Bolieve)
Copyright Neo Era Media, Inc. 1999-2016