Heavy form performance issue
One of my client complained about very slow opening of one form, which they use as a core functionality for supporting customer service calls. This form is really heavy equipped with many form controls, like grids, and dozen of linked data sources.
The behaviour was really strange: for some users it worked more or less fast, say, 3-6 secondes, for certains, on the contrary, it could take up to 25-30 secondes.
All of them were assigned to System admin role. No special security, like, RLS or whatsoever was implemented.
Trace Parser and Code Profiler showed that the sequence of the execution flow was the same; however, almost all of the methods executed as twice as longer for the"slow" user than for the "rapid" one.
The strangest thing was in the fact that Trace Parser showed inclusive execution time which was not the sum of all its including methods: evidently something happened behind the scene.
Another funny thing, after clearing the "slow" user's cache files, the first run was slow, which is normal, the second run was incredibly fast, as much fast as for the "rapid" users, but starting the third run it fell down to slowliness.
The key was actually in the small option as it explained on the article Configure client performance options:
Preload complex forms
By default, forms that include more than 80 controls are preloaded and added to a preload cache. When the user opens a form, the system checks the preload cache for a preloaded version of the form. If a preloaded version is found, the system completes the initialization process and loads the form. Not all forms are preloaded. If resource limitations are met, the system starts to remove forms from the cache, starting with the forms that were least recently used. Forms such as lookups, parts, preview panes, and system forms are excluded from this mechanism.
You can turn off preloading by using the following methods:
So, once I changed the latter for this heavy form that some users personalized, it started to open very fast for all of them.
I want to thank:
All my colleagues at work;
Freeangel and all other members from this thread (in Russian).
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.
|emeadaxsupport: AX Performance Troubleshooting Checklist Part 2||Blog bot||DAX Blogs||0||09.09.2014 16:11|
|dynamicsaxtraining: Vendor returns||Blog bot||DAX Blogs||0||11.10.2012 00:11|
|dynamicsaxtraining: Purchase||Blog bot||DAX Blogs||0||11.03.2012 05:25|
|Dynamics AX Sustained Engineering: Performance issue in "Open Transaction Edit" form||Blog bot||DAX Blogs||0||26.10.2009 20:05|
|wiki.dynamicsbook: Changes Made in Navision Attain 3.60||Blog bot||Dynamics CRM: Blogs||0||02.09.2008 13:23|
|Опции темы||Поиск в этой теме|