Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Spelling checking really slow
Message
De
02/11/2004 12:17:55
 
 
À
31/10/2004 15:47:04
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00956184
Message ID:
00957128
Vues:
25
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform