Microsoft Dynamics NAV (Archived)

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

(0) Share

Report

Posted on by Senthil Kumar Varat...

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

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

jcastro 2,245 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

Neville Foyn 4,320 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Sumit_Nandha 160 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Ashwini Tripathi 4,624 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (2)

Report

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...

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,594 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

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.

Was this reply helpful? Yes No