Monday, January 4, 2016

Slow AX form performance on AX 2009

Sometimes in AX Live environment where you keep constantly develop and update new functions, some users can encounter slowness on some forms but not others. It could be the issue with caching of the forms. Clearing the forms cache on all users can be the solution.

There is a table called SysLastValue, but thing is you cannot see this table in AOT. You will have to go to SQL server to see the table.

Check this link to learn more about the table.
https://msdn.microsoft.com/en-us/library/aa605024(v=ax.50).aspx

You can write a stored procedure to be called from AX.

Just be careful that if the clearing means the saved view of the form on users will be cleared as well.

No comments:

Post a Comment