Requesting Date (2000000007) takes a very long time

FalkNowack
FalkNowack Member Posts: 1
in NAV Three Tier
Hello,

has anyone any clue, why requesting the virtual table Date (2000000007) can take very long?

I wrote a simple codeunit for test:
DateRec.SETRANGE("Period Type", DateRec."Period Type"::Date);
StartDatetime := CURRENTDATETIME;
DateRec.FINDLAST;
EndDatetime := CURRENTDATETIME;
MESSAGE(STRSUBSTNO('%1 - Duration: %2 ms', DateRec."Period Start", EndDatetime-StartDatetime));

At my local machine (BC14), no duration is given because it's 0 or the duration is about 15 ms after restarting the nav service, but at the customers machine (also BC14) the duration is never below 2.5 seconds.

Best Answer

  • JJMc
    JJMc Member Posts: 63
    edited 2022-10-26 Answer ✓
    Restart the instance. You'll see

Answers

  • JJMc
    JJMc Member Posts: 63
    edited 2022-10-26 Answer ✓
    Restart the instance. You'll see

Categories