Hi,
We are having an issue with performance, that seems to be limited to certain users.
We have a form that uses the Customer table and from here to populate one of the fields you can choose from a picklist. The picklist opens the Customer table with a single filter turned on to clear out some non-relevant records.
The issue is when the picklist populates for certain users this can take up to a minute just to fill out the details on the picklist screen (often the whole screen freezes up, other times you can see the list slowly populating with details), whereas for other users it happens within a few seconds. I have checked filters and so on and they are all the same between users, so I can't see a reason as to why this would happen.
Extra system info:
Nav Version - 4.0 SP1
SQL - 2000
Any ideas on where to look for possible issues would be much appreciated.
Thanks
0
Comments
Do the user have the same permission?
In sql you can add additional security filters at record level.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
If the 'Slow users' have different terminals to the 'Fast users' have you had them login into these slow terminals and see if they are still affected by
the slow form load? and vice versa slow on fast terminal etc
If you can seperate outsomething like this you may find its not the code at all.
You can also create a new user who just access this form or warehouse, r u using scanners at all or handhelds?
We are using scanners here for some of the form data entry, how would that affect things?
I will attempt to hide a few of the flowfields and see if this helps in the search time.
In regards to regular index rebuilds and calculate stats, we haven't done this, I was mainly trying to use the Navision optimisation step on the table, but this seemed to have no real effect on retreive times.
Thanks again
It doesn't identify the cause i know but if it resolves the issue your client is happy. you could just create a test user based off a user who has no issue
and ask a slow user to use this one
I also checked all the flowfilters and there isn't any that are turned on when returning the list for either sets of users.
I also setup a new test account and gave it the same permissions as one of the "fast" users, yet when I use this test a/c it is one of the "slow" ones and takes around 30 seconds to retreive the list.
Thanks again for all the suggestions.