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