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 / Microsoft Dynamics AX (Archived) / Form refresh rate ques...
Microsoft Dynamics AX (Archived)

Form refresh rate question

(0) ShareShare
ReportReport
Posted on by lukbel 282

Hi all

Running Dynamics R3 CU9

It seems by default, after a form loads, scrolling to the right using the navigation bar at the bottom causes the form to reload data - you can see it jitter as it recalculates display methods etc. This can really slow the form down if there are a lot of records.

However, some default forms (SalesLineBackOrderListPage, for example) do not do this, regardless of the amount of lines they pull in. Is there some functionality that has been enabled that caches the initial value on the form?

Cheers

Luke

*This post is locked for comments

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,988 Super User 2026 Season 1 on at

    Hi Luke,

    What exact form are you referring to? Does it have customizations like added display methods? If so, caching of these methods could improve this behavior.

  • lukbel Profile Picture
    lukbel 282 on at

    The form I'm referring to is a copy of SalesLineBackorderListPage, with a few filters added to it. It has two added display methods, both of which are one-line InventTable::(this.ItemId).[fieldname] retrievals.

    I couldn't see if SalesLineBackOrderListPage includes any cached methods, as it has a few display methods built in. (This had also occurred to me.)

    I have only ever cached methods in X++ code where the tables were multiple data sources, linked together by X++ code themselves. How do you do this when the data source is a query?

    Thanks for your help so far, hopefully there is something obvious I am missing :)

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

    Have you cached the two added display methods? That's the only part which can be cached using x++ logic. Queries can be optimized using an SQL profiler.

  • lukbel Profile Picture
    lukbel 282 on at

    Hi André

    I haven't - where would I do this though? In the data source of the form against the table, or against the form itself?

    Before when I did it, every table was a data source against the form.

    Thanks

    Luke

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

    Hi lukbel,

    Please refer this blog post community.dynamics.com/.../tutorial-caching-display-methods

  • lukbel Profile Picture
    lukbel 282 on at

    Hi

    Thanks so much for this :) Didn't realise you could do it on the form control

    Cheers

    Luke

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Andrew Jones a1x Profile Picture

Andrew Jones a1x 2

#3
GL-01081504-0 Profile Picture

GL-01081504-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans