Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Application slow when using SELECT() function
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Application slow when using SELECT() function
Divers
Thread ID:
00962973
Message ID:
00962973
Vues:
36
Hi all,

My application has a big slowdown problem, only at one of my customer (he use Citrix to run the application)

I temporarily put in one of the slow method a time(1) at each line, to determine where is the slowdown in the method
LstrTime = lStrTime + " - " +TIME(1) +" ("+ALLTRIM(STR(lineno(1))) +")"
the result look like this...
... 15:59:37,02 (363) - 15:59:37,02 (367) - 15:59:37,01 (371) - 15:59:37,02 (375) - 15:59:38,22 (388) - 15:59:38,22 (392) - 15:59:45,75 (407) ....

For exemple I can determine that execution time between line 392 and 407 take about 7,53 sec.

I notice that this code was often very slow and take sometime more than 1 minute for this single line of code.
SELECT(lCurSel)
The lCurSel variable is initialised at the begining of the method with ALIAS() and it's a méméry cursor (result of a SQLEXEC())

I always use ALIAS() at the begining of my functions and SELECT() at the end to be sure to have se same selected cursor when calling a function... am i doing wrong?

Thanks for your help
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform