Performance problem with acces to object (Excel object)

[michal.orsag@…]

There is performance problem with access into Excel object in AutoIT version 3.3.8.0 compared with version 3.3.6.1. Especially if code is compiled with default setting in 3.3.8.0 and in 3.3.6.1 (3.3.8.0 is slower)

Prepare Excel into c:\excelTest.xls, fill column A with 'a', column B with '1' at least on 100 rows, save Excel. try to run or compile code and run in 3.3.6.1 and in 3.3.8.0 and see the differencies. Tried on MS Excel 2003 and 2007, same result

Code:

_Main()

Func _Main()
	Local $a = 1, $b = 0
	Local $start, $end, $total = 0
	Local $timeFile, $timeFilePath = 'c:\timeFile.txt'
	Local $oExcel = ObjGet('c:\excelTest.xls')

	$timeFile = FileOpen($timeFilePath, 2)

	While $oExcel.worksheets("List1").cells($a, 1).text <> ""
		$start = TimerInit()
		$b += $oExcel.worksheets("List1").cells($a, 2).text
		$end = TimerDiff($start)
		$total += $end
		FileWrite($timeFile, "Time=" & $end & @CRLF)
		$a += 1
	WEnd
	FileWrite($timeFile, "TotalTime=" & $total)
	FileClose($timeFile)

EndFunc ;_Main

[trancexx]

Versions before 3.3.8.0 were broken. Don't compare speed of broken thing with a speed of non-broken thing. The result you get when you do that is not valid.

[michal.orsag@…]

Replying to trancexx:

Versions before 3.3.8.0 were broken. Don't compare speed of broken thing with a speed of non-broken thing. The result you get when you do that is not valid.

So you think that it is correct, that in newest version (3.3.8.0) is access to Excel via COM much more slower (10 ms) than in previous version (3.3.6.1), where the access speed was about 1 ms?

[Jpm]

I think this ticket must be analyse carefully as Michal is right when he say the results are the same under 3.3.6.1 and 3.3.8.0 just the speed differ.

[anonymous]

Sorry ma English is not so good. Result is, that access Excel object via COM interface is much slower in 3.3.8.0 than in 3.3.6.1

Maybe there is relationship with bug ​http://www.autoitscript.com/trac/autoit/ticket/2002

[anonymous]

I moved back to 3.3.6.1 due to the fact that all scripts with access to Excel via COM are very very slow.

[tpek]

But. Now version 3.3.8.1 is not broken and is "stable". Problem still exist and this few miliseconds have very significant meaning. In thousands operations it causes big differences and I am very worried because of this.
​http://www.autoitscript.com/forum/topic/144510-excel-read-speed-differences-between-autoit-versions/