New
#1
Excel Macro running time on Windows 7 Pro GPT vs MBR performance
A while ago, I swapped a Windows 7 Pro MBR onto my HP 800 G1 using Paragon. It's my 1st Windows 7 MBR desktop. (I had been using Windows 7 Pro GPT). I did test my Excel macro running time and compared it on MBR vs on GPT.
test condition: Microsoft Office2010 on Windows 7 x64. running same macro script and same data on same HP 800 G1 computer, three times to average.
- running time on GPT format: 13-minutes (every time almost same, three times)
- running time on MBR format: 20-21 minutes (every time slightly different, three times)
Note. The MBR PC is by Paragon swap, not clean-installed. while the GPT one is by clean-install. the test is tedious because I needed to restore OS on same HP 800 G1 one-by-one. during my retest on the MBR PC, I later run CCleaner to clean up the OS. re-running but didn't see significantly different on test time.
The running time hints, the performance on GPT is superior to that on MBR, for my excel macro running on Windows 7 Pro x64.
Before my test, I did google Microsoft web and various forums (quora, tenforums, tomshardware , , ,). they claim "Neither one is faster.". " there should be no performance differences."
my testtime summary is obviously NOT supporting their claim.
Any thoughts on the longer running time on Windows 7 x64 MBR?
I would try my best to tune up the computer so that the performance similar to the GPT one. that's interesting.
If no solution, my choice will be GPT than MBR according to my test on performance.
Last edited by siliconbeaver; 20 Nov 2022 at 12:50.