Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Application slow when using SELECT() function
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Application slow when using SELECT() function
Miscellaneous
Thread ID:
00962973
Message ID:
00962973
Views:
37
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
Next
Reply
Map
View

Click here to load this message in the networking platform