Page loading too slow in NAV.

(0) Share

Report

Posted on by Sulav Raj Thapaliya

127

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.

All responses (1)

Answers (0)

Suggested answer

Teddy Herryanto (Th... 13,695 Moderator on at

Like (0)

Report

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.