Modify

Opened 12 years ago

Closed 12 years ago

Last modified 11 years ago

#2097 closed Bug (No Bug)

Performance problem with acces to object (Excel object)

Reported by: michal.orsag@… Owned by:
Milestone: Component: AutoIt
Version: 3.3.8.0 Severity: None
Keywords: Cc:

Description

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

Attachments (2)

timeFile_3361.txt (2.3 KB) - added by anonymous 12 years ago.
timeFile_3380.txt (2.3 KB) - added by anonymous 12 years ago.

Download all attachments as: .zip

Change History (8)

Changed 12 years ago by anonymous

Changed 12 years ago by anonymous

comment:1 follow-up: Changed 12 years ago by trancexx

  • Resolution set to No Bug
  • Status changed from new to closed

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.

comment:2 in reply to: ↑ 1 Changed 12 years ago by 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?

comment:3 Changed 12 years ago by 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.

comment:4 Changed 12 years ago by 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

comment:5 Changed 12 years ago by 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.

comment:6 Changed 11 years ago by 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/

Guidelines for posting comments:

  • You cannot re-open a ticket but you may still leave a comment if you have additional information to add.
  • In-depth discussions should take place on the forum.

For more information see the full version of the ticket guidelines here.

Add Comment

Modify Ticket

Action
as closed The ticket will remain with no owner.
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.