Wednesday, May 20, 2015

Calculate timing in X++ operations [WinAPI::getTickCount()]

While reading some lengthy operations e.g. reading data from CSV files, fetching data in query and uploading data etc I wanted to know the time consuming in each opertion. This helped me to optimize my logic or query in making client-server calls.
We can use following function to know about time consumption;

int                 startTime, endTime;

startTime = WinAPI::getTickCount();
[Perform X++ operations]
endTime = WinAPI::getTickCount();

info(strFmt('It took %1 minutes', ((endTime - startTime)/1000)/60));

Note: WinAPI::getTickCount() tells time in milliseconds you need to change accordingly as per your required unit.

No comments:

Post a Comment

I will appreciate your comments !

Download large bacpac (sandbox database) to DEV environment much faster

As the LCS website gets slower and slower and the database backups get bigger and bigger.  Use AZCopy to download objects out of LCS asset l...