Skip to main content

Notifications

Finance forum

Form performance

Posted on by 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

  • Pete Alberts Profile Picture
    Pete Alberts 3,542 on at
    RE: Form performance

    Sorry for the late reply. Here it is:

    1. I was on the wrong track. I was told that "XYZForm" takes long to load. XYZForm should've been a single details master. But instead it consists of a ListPage and a DetailsMaster. (I actually posted a question on whether it is safe to fix this.)
    2. On my box, XYZFormListPage takes around 40 seconds to load. So I assumed that the problem is the list page. Which was incorrect. That performance issue is only on my VM - it struggles with any form that needs to load more than 30 records (everything else on my VM is fine and fast). I haven't had the time to address that issue. But, that is the reason that I thought that XYZFormListPage is the problem.
    3. The real form that took long to load (the client's problem) was XYZFormDetailsMaster.
    4. I used that trace parser to some extent. The main culprit were some Tree controls. I solved that by improving and moving code and not drawing the entire tree. The trees get quite big, so a node's sub nodes only gets built once it is opened. I am only half way - I became (and still am) occupied with other work of higher importance.
  • Pete Alberts Profile Picture
    Pete Alberts 3,542 on at
    RE: Form performance

    I'm working on a reply. I've got some other pressing work

  • Mea_ Profile Picture
    Mea_ 60,278 on at
    RE: Form performance

    Sure we are interested

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,228 Super User 2024 Season 2 on at
    RE: Form performance

    Hi Pete,

    I'm interested  :)   You may also send me a private message with the details.

  • Pete Alberts Profile Picture
    Pete Alberts 3,542 on at
    RE: Form performance

    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.

  • Pete Alberts Profile Picture
    Pete Alberts 3,542 on at
    RE: Form performance

    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.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,228 Super User 2024 Season 2 on at
    RE: Form performance

    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.

  • Verified answer
    Sukrut Parab Profile Picture
    Sukrut Parab 71,647 Moderator on at
  • Verified answer
    Mea_ Profile Picture
    Mea_ 60,278 on at
    RE: Form performance

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

  • Pete Alberts Profile Picture
    Pete Alberts 3,542 on at
    RE: Form performance

    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)

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

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans