on 01-21-2015 11:43 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Good place to start from Sergiy.
Also it looks like the system is retrieving SFCs in work for the Op/Res combination to populate POD work list. Thus my assumption is that problem might be with SQL queries related to identifying SFCs in work. Is WIP DB big for this system? Do you see the same behaviour for operations/resources with small amount of SFCs in work?
Regards,
Konstantin Chernega
Hi,
We found some indexes need to be rebuilt in WIP. POD query does not hit the index and the query take ~45 sec to run.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Pete,
5 cents from my side: I had worked on a case where the slowness was caused by Info Lines in POD. Please, check in the POD Maintenance, POD Selection tab Info Line 1 and Info Line 2 values. You can set them to None if you do not really use them, it will help to improve the performance.
Br, Alex.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
6 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.