Hi everyone,
When I am opening the All production order list page, or any list page having huge amount of data in the table, which is used in the query for the list pages taking too much time to open .
is there any way that i can do for improving the performance , can anyone please suggest me?
Regards,
Pankaj Kumar
*This post is locked for comments
Are you doing regular DB maintenance (index/statistics update), do you have recommended/optimized settings for your SQL Server (number of TempDB and Database data files, Trace Flags, read committed snapshot, dataAreaLiterals, etc.) set? Typically performance issues are due to lack of any of the above.
Check my article on this for AX DB health and make sure you also follow the recommendations in the PFE blog:
Hi Pankaj,
Also check if you have customizations. In general when using inner joins with other tables, the full result set will be loaded before displayed on the list page. Without these inner joins, it will run faster.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (