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
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.
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.
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...
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.
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
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
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?
#1
André Arnaud de Cal...
291,391
Super User 2024 Season 2
#2
Martin Dráb
230,445
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
