So if you are asking a real question and are using big data, I would say get a gaming motherboard that can overclock, buy an i7 CPU with the letter K on the end (K means it is unlocked), but water cooling instead of cheap fins and fan to cool cpu, and build machine at home. Then if file is already made, say big data dump, 800,000 rows, and 25 columns of columns doing dictionary lookups etc, it will use all 32 cores 100%. So if you have 1GZ ram you will be literally 100% faster with 2400MZ ram, I know from 3 machines at home. This means you need the highest GZ CPU speed possible, AND fast ram. Quite often, it only uses 1 core if doing things that use clipboard. My current machine at work is a dual xeon with 32 cores (each is 8 physical cores and hyperthreaded). I've done a lot of testing, and have used all excel thru 2010 64 bit. Thanks again.On the physical side I have extensive experience, real world. Input is appreciated I am going to evaluate this based on # threads, etc. and godfather I've been testing my excel worksheet onĮxcel 2007 on different computers including I5's and I7's. The only sure way to know is to do some testing with your particular Excel workbook. If you are multi-threaded to more than 8 formula chains, then have a look at Intel Core i7-3960X, Intel Core i7-3930K or AMD Opteron 6274. So if you are single threaded, and don't want to overclock, then maybe the Intel Core i7-2700K or Intel Core i7-3820 is the best. 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. The degree of improvement depends on how many independent calculation trees the workbook contains. When Excel loads a workbook, it determines from the operating system how many processors are available and then creates a separate calculation thread for each processor. Starting in Excel 2007, Excel splits calculation across multiple processors or cores. In this case it doesn't make sense to get a 6 or 8 core CPU. Versions of Microsoft Excel earlier than Excel 2007 use a single thread for all worksheet calculations. The following is a para-phrased summary from the Microsoft site, Will depend on what version of Excel you are using, the structure of your worksheet and if you want to get into overclocking.
0 kommentar(er)
