Skip to main content
Microsoft Dynamics NAV forum
Suggested answer

Page loading too slow in NAV.

editSubscribe (0) ShareShare
ReportReport
Posted on by 125

Hello All,

I have created one table "X Table Name" where there are around 55 million records whose primary key is only "Entry No.". I created one simple list page by using one of the filters as posted = false but the time taken to load that page is too long. I added some secondary keys in table as well but no luck. Is there anything I can further do to improve the page performance drastically in NAV?

Any help would be appreciated.

Attachments
  • Suggested answer
    TeddyH Profile Picture
    TeddyH 12,726 Super User on at
    RE: Page loading too slow in NAV.

    Add a key with "Posted" on the table.

    And use that key on the page as the default sorting.

    Since you have a huge amount of records, it will hard to improve the performance drastically.

    You may need to consider BI tool to get the data directly from SQL.

Helpful resources

Quick Links

New Blog Features Released!

Check out the new community blog features for viewers and authors…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,126 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,646 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Featured topics

Product updates

Dynamics 365 release plans