id	summary	reporter	owner	description	type	status	milestone	component	version	severity	resolution	keywords	cc
2097	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
}}}"	Bug	closed		AutoIt	3.3.8.0	None	No Bug