>>I am sure this has been addressed before. But I would appreciate some quick help.
>>
>>I am performing some performance testing and have discovered that the Seconds() function may not be actuate. I discovered a UDF based on the SYS(2015), but I question its return. I would like to use the WinAPI GetTickCount(), but it only returns True, no tick count.
>>
>>Any other suggestions?
>
>Based on code Mike Yearwood once wrote, while we were discussing performance issues:
>
>

>#DEFINE LOOP_LENGTH 100000000
>
>LOCAL Start AS Datetime
>LOCAL Stop AS Datetime
>LOCAL LoopIndex AS Number
>
>LOCAL Buffer1 AS String
>LOCAL Buffer2 AS String
>LOCAL CurrentTickCount AS Number
>LOCAL ElapsedSeconds AS Number
>
>DECLARE INTEGER QueryPerformanceFrequency IN kernel32 STRING @Frequency
>DECLARE INTEGER QueryPerformanceCounter IN kernel32 STRING @PerformanceCount
>
>m.Buffer1 = SPACE(8)
>m.Buffer2 = SPACE(8)
>
>QueryPerformanceFrequency(@m.Buffer1)
>
>m.TicksPerSecond = CTOBIN(m.Buffer1, "8")
>
>m.Start = DATETIME()
>QueryPerformanceCounter(@m.Buffer1)
>
>FOR m.LoopIndex = 1 TO LOOP_LENGTH
>	* dummy
>ENDFOR
>
>m.Stop = DATETIME() - m.Start
>QueryPerformanceCounter(@m.Buffer2)
>
>m.ElapsedSeconds = (CTOBIN(m.Buffer2, "8") - CTOBIN(m.Buffer1, "8")) / m.TicksPerSecond
>
>? TEXTMERGE("<<m.Stop>> (based on DateTime) versus <<m.ElapsedSeconds>> (based on Win32)")
>

A better comparison is done via measuring a couple code stretches / single lines each a high double digit of counts and compare the variance of the result sets for each line measurement between gettickcount and QueryPerf ;-)