web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance forum / Form performance
Finance forum

Form performance

(1) ShareShare
ReportReport
Posted on by Pete Alberts 3,542

Form X takes an average of 35 seconds to load (at the client). I did not develop the form - I suspect it comes from AX2012.

I read the following post which was very helpful: https://community.dynamics.com/ax/f/33/t/87286

Mr Drab's verified answer to the problem is very extensive and a bit over my head. I need a bit more specific answer, if possible. I was wondering if someone could help me with a simpler list of properties/code I can play with to improve the performance of the form.

Some details:

  • Form pattern: List Page
  • Custom code on form: a single displayOption() method
  • Form Data Source Query is specified with a query that has a single datasource (so I don't think the query is necessary? - it seems redundant)
  • Table cache lookup: none (I am planning to set it to Found&Empty)

Properties that I am aware of that may have an influence:

  • Table indexes
  • Form Data Source "Maximum Records to Load" property

Are there other simple-ish "things" (properties/code) I can look at or try to improve the forms performance?

Thanks for reading

Please let me know if I am unclear

Categories:
Development / Customization / SDK
Performance
I have the same question (0)
  • nmaenpaa Profile Picture
    nmaenpaa 101,166 Moderator on at

    Is there a range in the query? Are the fields in the range covered by an index in the table?

    What code is in displayOption method? Is the form faster if you comment it out?

    Are there display methods in the grid? What code is in them?

  • Pete Alberts Profile Picture
    Pete Alberts 3,542 on at

    No query range.

    No display methods

    Display option removed doesn't make much of a difference.

    Setting "Maximum records to load" to something else than -1 results in a decent improvement.

  • Pete Alberts Profile Picture
    Pete Alberts 3,542 on at

    The query is cross company - I only realized that now.

  • Mea_ Profile Picture
    Mea_ 60,286 on at

    Hi Pete Alberts,

    First tool to use when you have performance issues is trace parser, did you try to capture a trace?

  • Pete Alberts Profile Picture
    Pete Alberts 3,542 on at

    Thanks Ievgen.

    It will be the first time I use it... I am busy with other work at the moment. I found this link which I will read before I start this project: docs.microsoft.com/.../trace-trace-tutorial Is that what you were referring to?

    And do you maybe have a guess what the issue might be? (Based on the info I provided)

  • Verified answer
    Mea_ Profile Picture
    Mea_ 60,286 on at

    Yes, that's the tool. No reason to guess if you can see what is slow and why.

  • Verified answer
    Sukrut Parab Profile Picture
    Sukrut Parab 71,710 Moderator on at

    Here are some links about how to use trace parser -

    blogs.msdn.microsoft.com/.../walk-through-major-features-of-microsoft-dynamics-ax-2012-trace-parser-part-1

    blogs.msdn.microsoft.com/.../walk-through-major-features-of-microsoft-dynamics-ax-2012-trace-parser-part-2

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,363 Super User 2026 Season 1 on at

    Hi Pete,

    Is this question related to AX2012 or Dynamics 365? You posted the question in the MSDyn365FO forum and mentioned AX2012. Like mentioned above, the trace parser can help in both product versions.

  • Pete Alberts Profile Picture
    Pete Alberts 3,542 on at

    Thank you Sukrut and Andre.

    Andre - I only mentioned that I suspect the form comes from AX2012. This is for D365.

    I don't know how to correctly word what I want to say... Here is an attempt: The form was created in AX2012 in model X and came to D365 when model X was upgraded from AX2012 to D365. And it hasn't been modified since. I mentioned it because the pattern is List Page (I understand in D365 we should use Simple List) and because I'm trying to give as much info as possible (Martin kindly asked me), so I thought it might be relevant. But I probably should've left that detail out.

    Myself and a consultant are currently busy with the whole trace parser process. I will update this thread shortly.

  • Pete Alberts Profile Picture
    Pete Alberts 3,542 on at

    Trace Parser helped me to find the issue. Thanks all.

    It was not the List Page that created the issue. It's quite a long story. If someone wants to know, I'll provide the information.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Finance

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans