Excel writing time is inconsistent.

We are having vb script to read XML and write it into excel.In one machine excel writing is taking 15 mins in another
machine it is taking more than 1 hr. what is the reason behind this issue and how to make the excel writing time constant for all the machines?
Please help me to find a solution for this issue.

Are all machines the same? Do they have the same processor?

alansidman said:

Are all machines the same? Do they have the same processor?

Click to expand...

All machine cannot be same, but in same machine also time for excel writing is inconsistent


Below table is the bench marking time of excel writing in 3 different machine and added observation on same machine also(same machine also excel writing is taking different time Refer row1 and row2).


Code:
Machine Name Excel writing time OS Processor


Machine 1 (32 GB) 1 hr windows 10 pro Intel(R) Xeon(R) CPU E5-1620 v4 @ 3.50GHz, 3501 Mhz, 4 Core(s), 8 Logical Processor(s)
Machine 1 (32 GB) 36 mins windows 10 pro Intel(R) Xeon(R) CPU E5-1620 v4 @ 3.50GHz, 3501 Mhz, 4 Core(s), 8 Logical Processor(s)
Machine 2 (32 GB) 15 mins windows 10 pro Intel(R) Xeon(R) CPU E5-1620 v4 @ 3.50GHz, 3501 Mhz, 4 Core(s), 8 Logical Processor(s)
Machine 2 (32 GB) 30 mins windows 10 pro Intel(R) Xeon(R) CPU E5-1620 v4 @ 3.50GHz, 3501 Mhz, 4 Core(s), 8 Logical Processor(s)
Machine 3 (64 GB) 3 hrs 26 mins Microsoft Windows 7 Professional Intel(R) Xeon(R) CPU E5-1620 v4 @ 3.50GHz, 3501 Mhz, 4 Core(s), 4 Logical Processor(s)