Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Customer List Page very slow while fetching the records. - How to optimize table in NAV 2013 R2

Posted on by 205

Hi friends,

Issue :  Customer List very slow while fetching the records.

Details : total number of records  : 320,000 , Key : No., Maintain Sql indexing  - True, Maintain SIFT index, cluster index, Sql Index - No.

Kindly give me the solution, how to optimize the customer table.

 

Thanks & Regards,

Senthil Kumar V.

*This post is locked for comments

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Customer List Page very slow while fetching the records. - How to optimize table in NAV 2013 R2

    Check the filters put on the customer page and check if that same field is used somewhere in flowfield . You need add that in key of the table

    This is what I experience long time back in 2013 R2 and once I added that field in key problem resolved.

  • Suggested answer
    RockwithNav Profile Picture
    RockwithNav 6,562 on at
    RE: Customer List Page very slow while fetching the records. - How to optimize table in NAV 2013 R2

    Hey Senthil,

    In support to all other members, most in common reason of performance mainly Includes

    1. Many Flowfields in the Table.

    2.  Overloaded code on OnOpenPage, OnAfterGetRecord and OnafterGetCurrentRecord triggers of the Page.

    I dont belief the count of the records is gonna have Impact on Performance in your case because I have experienced a record level of around 1000000 but never felt performance Issue in Page opening.

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: Customer List Page very slow while fetching the records. - How to optimize table in NAV 2013 R2

    Sumit,

    It could be of multiple reasons, one thing would be if have inluded so many flowfields, or the customizations (if there are any), check if there is any code on the OpenPage Trigger or OnAfterGetRecord triggers. Try to modify the list to display one or two columns and check if that improves the performance...

  • Suggested answer
    Ashwini Tripathi Profile Picture
    Ashwini Tripathi 4,624 on at
    RE: Customer List Page very slow while fetching the records. - How to optimize table in NAV 2013 R2

    Please limit to bare minimum flowfields on page. Hide them if user require can make them visible.

    Larger the no of flow fields will slow down the loading of page. Even if you Link with Factboxes.

    Avoid flow fields if it not certainly required on pages.

  • Suggested answer
    Sumit_Nandha Profile Picture
    Sumit_Nandha 160 on at
    RE: Customer List Page very slow while fetching the records. - How to optimize table in NAV 2013 R2

    Yes have same problem , list page is getting to slow when you scroll, server have 48gb ram and all things good and fater but only customer list page is slow. i have try all thing you have suggest , same issue in customer table run 

  • Suggested answer
    Neville Foyn Profile Picture
    Neville Foyn 4,320 on at
    RE: Customer List Page very slow while fetching the records. - How to optimize table in NAV 2013 R2

    Yep, as Jose said this is very often as a result of too many flowfields, and complex flowfields, try removing the custom flowfields and see what impact that has on performance

    If it works then you may need to find an alternative solution for the developments using those flowfields

  • Suggested answer
    jcastro Profile Picture
    jcastro 2,245 on at
    RE: Customer List Page very slow while fetching the records. - How to optimize table in NAV 2013 R2

    Hello Senthil,

    Has it always been this way? Or did it start working slower over time? Is it a new implementation/upgrade?

    Also, is the system slow overall or just that list? I have seen lists being very slow due to having way more fields than necessary (specially flowfields). Is this the case? Could you try to hide some fields (right click on the header of the list>Choose columns) and reopen the page? Is it still as slow?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans