New Posts  All Forums:Forum Nav:

Excel Benchmark - Page 6

post #51 of 111
I run the benchmark on 8700k It seems to only run on one core so no multi threading for excel? checked thread usage with HWInfo64 while the benchmark ran.
post #52 of 111
CPU: i5 4670K
#Cores: 4 (no HT)
CPU clock speed: 4,3 GHz
Total system memory: 16 GB
memory speed: 1866MHz
Excel ver.: 2013
time to sort in seconds: 130,43
post #53 of 111
Thread Starter 
Quote:
Originally Posted by japau View Post

I run the benchmark on 8700k It seems to only run on one core so no multi threading for excel? checked thread usage with HWInfo64 while the benchmark ran.
Which excel version? Sounds like multi-threading came on in 2010.
post #54 of 111
Newest Office 2016 professional (windows 10 pro 64bit)

I managed to run 95sec so its in line with the other posters, so i think none has seen 100% usage on all threads.
post #55 of 111
Thread Starter 
Quote:
Originally Posted by japau View Post

Newest Office 2016 professional (windows 10 pro 64bit)

I managed to run 95sec so its in line with the other posters, so i think none has seen 100% usage on all threads.
To be fair, the purpose of the benchmark is not a CPU benchmark, but rather a way to see what systems perform best with regards to Excel usage.

I wanted people who are building a workstation around Excel and were on the fence between a 7700k and a 1700x (like me) to have data to back up their build decisions.
post #56 of 111

    
CPUMotherboardGraphicsRAM
Intel Core i7-4790K ASRock Z97 OC Formula; ASUS MAXIMUS VII HERO; G...  EVGA GTX 1060 SC GAMING 6 GB G.SKILL F3-1866C8D-16GTX 
Hard DriveHard DriveHard DriveHard Drive
Samsung 850 EVO 250 GB SanDisk Extreme Pro 240GB Samsung 840 PRO 128GB Plextor PX-128M5S 128GB 
Hard DriveCoolingCoolingCooling
WD 1002FAEX 1TB Caviar BLACK (in enclosure) Noctua NH-D15S Corsair H110 2 x Noctua NF-A14 industrialPPC-2000/3000 PWM ... 
CoolingCoolingCoolingOS
Case Fan: 1 x Noctua NF-A14 PWM (rear, exhaust) Case Fan: Noctua NF-S12A PWM (front, intake) Case Fans: 2 x Noctua NF-S12A FLX (front, intake) Windows 10 Pro 64 bit 
OSOSMonitorMonitor
Windows 10 TP KDE Neon Developer Stable HP ZR2440w Dell U2311H 
KeyboardPowerCaseAudio
Microsoft Ergonomic keyboard 4000 Corsair AX760 (Platinum); EVGA SuperNova 750 G2 Corsair Air 540 Asus Xonar Essence STX II 
AudioOtherOther
Sennheiser HD 600 Aquaero 5LT  THRUSTMASTER GPX LIGHTBACK FERRARI F1 GAMEPAD 
  hide details  
Reply
    
CPUMotherboardGraphicsRAM
Intel Core i7-4790K ASRock Z97 OC Formula; ASUS MAXIMUS VII HERO; G...  EVGA GTX 1060 SC GAMING 6 GB G.SKILL F3-1866C8D-16GTX 
Hard DriveHard DriveHard DriveHard Drive
Samsung 850 EVO 250 GB SanDisk Extreme Pro 240GB Samsung 840 PRO 128GB Plextor PX-128M5S 128GB 
Hard DriveCoolingCoolingCooling
WD 1002FAEX 1TB Caviar BLACK (in enclosure) Noctua NH-D15S Corsair H110 2 x Noctua NF-A14 industrialPPC-2000/3000 PWM ... 
CoolingCoolingCoolingOS
Case Fan: 1 x Noctua NF-A14 PWM (rear, exhaust) Case Fan: Noctua NF-S12A PWM (front, intake) Case Fans: 2 x Noctua NF-S12A FLX (front, intake) Windows 10 Pro 64 bit 
OSOSMonitorMonitor
Windows 10 TP KDE Neon Developer Stable HP ZR2440w Dell U2311H 
KeyboardPowerCaseAudio
Microsoft Ergonomic keyboard 4000 Corsair AX760 (Platinum); EVGA SuperNova 750 G2 Corsair Air 540 Asus Xonar Essence STX II 
AudioOtherOther
Sennheiser HD 600 Aquaero 5LT  THRUSTMASTER GPX LIGHTBACK FERRARI F1 GAMEPAD 
  hide details  
Reply
post #57 of 111

Great idea, will test my system tommorow.

post #58 of 111
Firstly, awesome project! I am so impressed at how far this project has come in just a week. I want to thank @ir88ed and @huzzug, good work guys!

I did some testing with my 14 core chip today. I tested a few different variables to see what effects the total run time. The results are surprising to say the least.

Here is my test setup:
  • New install of W8.1 64
  • Office Pro 2010


Core/Thread Testing i9 7940X
14 Cores / 28 Threads = 93.93 seconds
14 Cores / 14 Threads = 93.26 seconds
2 Cores / 2 Threads = 93.29 seconds

In the pictures below you can see, there is basically no scaling potential with core/thread count. If you watch the cores while the bench is running you will see that only 50% of 1 core is being utilized. The score difference is negligible.
Core Test Screenshots (Click to show)
14/28


14/14


2/2




Amount of Memory
31.8 Gb usable by OS = 93.93 seconds
2.4 Gb usable by OS = 93.68 seconds

I am using quad channel (8x4) for both tests. To test less memory I used a console command to limit the amount of memory the OS can use. I reused the 32GB score from my core testing since its the same 14/28 for the baseline. As you can see, there is basically no scaling potential with the physical amount of memory. The score difference is negligible.
Amount of Memory Screenshots (Click to show)
31.8Gb System Memory


2.41Gb System Memory




Memory Timings
CL16-16-16-36 2T = 93.68 seconds
CL12-11-11-24 1T = 91.4 seconds
For this test I will compare the timings only. The DRAM frequency will be 3600 for both tests. The test only compares super tight timings vs XMP timings. In order to run super tight memory with high frequency in 64bit OS's, the amount of memory used by the OS needs to be less than 4gb. For this test I will reuse my result from the memory quantity testing as the baseline.

Finally we see a gain!! This is logical, we expect the performance to be increased with tight timings.
Memory Timings Screenshots (Click to show)
3600 CL16-16-16-36 2T


3600 CL12-11-11-24 1T



Thats all for now, but I have more tests planned for the future. Next time I run some LN2 on 7740X, I will try and run this bench at high frequencies and see what happens
cheers.gif
24/7 BENCH
(9 items)
 
  
CPUCPUMotherboardGraphics
[LGA115x] 7700K, 7350k, G3258 [LGA2066] 7940X, 7740X [OCF FTW] X299 OCF, Z170M OCF, Z97 OCF E-Power, G-Power, H-Power...WTB A-Power 
RAMCoolingCoolingPower
B-DIE, HYKO, PSC, MFR Kingpin Venom 6.66 2x360 RAD Custom Loop Seasonic Prime Platinum 1200W 
Case
Dimastech Easy V3.0 
  hide details  
Reply
24/7 BENCH
(9 items)
 
  
CPUCPUMotherboardGraphics
[LGA115x] 7700K, 7350k, G3258 [LGA2066] 7940X, 7740X [OCF FTW] X299 OCF, Z170M OCF, Z97 OCF E-Power, G-Power, H-Power...WTB A-Power 
RAMCoolingCoolingPower
B-DIE, HYKO, PSC, MFR Kingpin Venom 6.66 2x360 RAD Custom Loop Seasonic Prime Platinum 1200W 
Case
Dimastech Easy V3.0 
  hide details  
Reply
post #59 of 111
I still have the test with the entire 60K rows of data, but also 10K & 5K as well. Let me know if anyone of you want to run them as well. For giggles
post #60 of 111
Tested Ryzen 7 1700X at stock again.

There's some variance on XFR kicking in and also with antivirus.

Original sheet without timer is roughly 3 min 24 seconds. My original run the other day had 3 min 29 seconds on first run.

Huzzug's variation with a fresh boot obtained 212.46 seconds. I noticed the antivirus icon kick in on the first run. Closing Excel and running again resulted in 199.29 seconds.

I really don't know what to make of it because I definitely obtained 30 seconds the other day.
New Posts  All Forums:Forum Nav:
  Return Home