You’re offline. This is a read only version of the page.
10
Hi everyone,
For two users saving changes on some form takes a lot of more time than for others. Giving them system administrator right doesn't change anything. It's not machine related too. When I was analyzing it with Trace Parser I noticed some pattern inside FormDataSource::Write method that doesn't happen for other users. So I've created new table with only one field and simple form with grid and button that invoke Research method on the dataSource. Same thing happened, I highlighted it with green color below. On the server everything is same even sql.
If there is more datasource then there is more of those things
It is not a problem on simple forms but every single 4ms FormDataSource::Write method that you can see below on left takes 1s on the right and those findRange methods is the most visible different everywhere so I thing it is related.
Does anyone have an idea why those two users have that findRange additives everywhere or how can I investigate what happened here?
Thank you André Arnaud de Calavon. Everything was because of "Filter by grid on by default" option.
Hi WithCodeThroughWorld,
Can you check if there are differences in the user options between the users? E.g. some settings are different on the Development and SQL tab? It might be the case that these users are not running the business logic in CIL or if e.g. some SQL logs are enabled.
Thank you for your response André Arnaud de Calavon,
If alerts means just Organization administration/Setup/Alerts/Alert tracking then no, those users don't have any alerts set. I think It's even doesn't matter because I don't have to remove or write something, just invoke Research is sufficient. It is always a lot faster for other users. I'm doing it on special environment when I have copied database and even if no other user are logged in in this environment same things happen. As you can see below, on the left invoking ExecuteQuery is faster (Exclusive) than on the right and it's always like this. Also it's always a lot of more "FindRange" inside it, and I don't know why.
Hi WithCodeThroughWorld,
As you mention that the system administrator role doesn't improve the time, I do assume it is not related to security settings or potentially XDS policies.
What tables and form are involved here? Do these users have e.g. alerts enabled on this table?
Is it always that slow or sometimes performing better?
Thank you for your response,
I have cleaned usage data but nothing changed.
The problem with performance for those two users happens on every computer. Other users that log in on the same computer doesn't have problems.
As I said in previous post even on very simple form with empty table I can always see some differences for those users. Invoking FormDataSource::executeQuery or FormDataSource::Write takes more time and there are FindRange methods inside it while watching with AX Trace Parser. I only need to invoke Research method on datasource to see it. I can't debug research method because it's probably kernel method or something. On the server side there is not much differences (I mean from the AX Trace Parser perspective Ax32Serv.exe).
Maybe there are some settings somewhere in AX that make form datasources refresh differently?
Hi,
Have you already tried cleaning the usage data of the users affected?
Also, I wonder what happens if somebody of the other users that don't see the issue log into AX from the computer of the ones that have problems. Have you tested that already?
Best regards,
Ludwig
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (