Breaking news from around the world
Get the Bing + MSN extension
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2019 release wave 2 Discover the latest updates and new features to Dynamics 365 planned through March 2020
Release overview guides and videos Release Plan | View virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
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.
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.
Business Applications communities