Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Spelling checking really slow
Message
From
02/11/2004 12:17:55
 
 
To
31/10/2004 15:47:04
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00956184
Message ID:
00957128
Views:
24
>There is also an older article in MSDN on vfp, performance and COM showing that if each object has to be discovered across COM [loCOM.Tables[1].Sheet[1].Cell[i, j] or something similar from excel] in a single line this can put a serious damper on performance. I think the article was still vfp6 based and put only forward as tip the hint to set a object reference "down the line" of the COM object.
>
>Instead of
>for lnRun = 1 To
>  lctext = loCOM.Tables[1].Sheet[1].Cell[i, lnRun]
>endfor
>
>
>use
>
>
>loObj = loCOM.Tables[1].Sheet[1]
>for lnRun = 1 To
>  lctext = loObj.Cell[i, lnRun]
>endfor
>How the "for each" works in this aspect (you have to "get" the object FROM COM as well: DUNNO <g>.
>Here I'ld try walking explicitly [via index] across the lowest, already early bound COM object reference.

The code I am using is already using the lowest COM object reference. I also have to fix first the problem as to know why this is running extremely slow on this PC as oppose to others who tested it.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform