12.4. Efficiency Issue of the Explosion of MPS and MRP


If any data on the aforementioned screens is changed, the results of MPS and MRP can become outdated. Thus re-run of MPS and MRP is probably needed.

Running MPS or MRP may seriously slow down the database server. Let users know this side effect before the run or avoid running these business logic processors during business peak times.

MRP runs derive independant requirement and scheduled receipt for items (and item attributes). The runs scan all the involved historical records from many tables. As a result, the run time of MPS and MRP increases as the amount of data increases.