Performance issue in List pages..

Like (0) Share

Report

Posted on 13 Nov 2017 11:36:02 by Community Member

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

All responses (2)

Answers (0)

Suggested answer

Vilmos Kintera 46,149 on 14 Nov 2017 at 11:51:53

Like (1)

Report

RE: Performance issue in List pages..

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:

www.daxrunbase.com/.../ax-database-tuning-and-maintenance
André Arnaud de Cal... 293,406 Super User 2025 Season 1 on 13 Nov 2017 at 11:45:25

Like (1)

Report

RE: Performance issue in List pages..

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.