Calculate time to open a page in NAV

Answers

• Options

  Slawek_Guzek Member Posts: 1,690

  2018-09-04 edited 2018-09-04

  I'd try to profile performance using some test code/procedure, and collecting timestamps before/after calling CALCFIELDS on the field. It would give me a clear starting and ending point, and a precise time used to calculate the flowfield. Of course the code would have to be a bit more advanced, lopping through a few records and averaging CALCFIELDS calculation time over a few different source records/ few trials.
  
  Doing similar thing on the page might be tricky; you could try to remember the CURRENTDATETIME in some global var in OnInit or OnOpenPage trigger, and then calculate elapsed time in OnAfterGetCurrentRec, displaying the result in MESSAGE call, or storing it in some log file.

  Slawek Guzek
  Dynamics NAV, MS SQL Server, Wherescape RED;
  PRINCE2 Practitioner - License GR657010572SG
  GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03

  1
• Options

  robbonick Member Posts: 40

  2018-09-05

  I would use the performance profiler..
  
  https://blogs.msdn.microsoft.com/nav/2014/07/04/introducing-the-microsoft-dynamics-nav-application-profiler/

  2