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

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

MCP · Azure DevOpsYour delivery board, readable by an agentMCP · DataverseOne consent, and the data layer opensMCP · Dynamics 365 F&OConnecting F&O to an agent Microsoft hasn’t documented
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.
Previous article← Building query AND using query object in X++
Discussion

Ask a question or leave feedback

This is a review interaction. The WordPress version will store, thread and moderate comments.

Thanks — submitted for moderation in this review.
Search the whole site · Ctrl/⌘ + K