tkivinen
Member
We use serialized inventory items and process large quantities at a time (PO's with 1 to 10 lines and 500+ quantity per line) in ERP8 SP22 and I've noted a few performance bottlenecks.
1 - Grid warnings in P4312 and P42053 get exponentially slower. See post in Developer section called "Grid Error/Warning Performance". This was HUGE.
2 - P42053 Multi-location has poor cache management when dealing with 500+ items. I added a second index by serial number, and change the logic in "Grid Row is Exited & Changed - Async" to make one indexed cache lookup, rather than sequentially read the cache.
3 - I am aware of a performance problem in P4312 End Doc, getting slower with higher quantities. Haven't tracked it down yet.
4 - P4205 Pick Confirm "End Doc" also gets slower with higher quantities. N4200790 calls B4200450, B4200450 calls N4900440, N4900440 calls N4900270 document select. We don't use Document Sets (shipping preference 30), so we disabled the function call to N4900270. This cut our time in half at qty 100.
Hope this helps.
Todd K
1 - Grid warnings in P4312 and P42053 get exponentially slower. See post in Developer section called "Grid Error/Warning Performance". This was HUGE.
2 - P42053 Multi-location has poor cache management when dealing with 500+ items. I added a second index by serial number, and change the logic in "Grid Row is Exited & Changed - Async" to make one indexed cache lookup, rather than sequentially read the cache.
3 - I am aware of a performance problem in P4312 End Doc, getting slower with higher quantities. Haven't tracked it down yet.
4 - P4205 Pick Confirm "End Doc" also gets slower with higher quantities. N4200790 calls B4200450, B4200450 calls N4900440, N4900440 calls N4900270 document select. We don't use Document Sets (shipping preference 30), so we disabled the function call to N4900270. This cut our time in half at qty 100.
Hope this helps.
Todd K
