MSC Pre Process Worker (MSCPPW) Performance
we have load flat file(po,work order,sale order,reservation,onhand,item,catagory_Item,customer info, supplier info) from external system, we have 10 instances from legacy system.
Is it possible to launch request as below in parallel ?
Flat File Loader
Loader Worker
Pre-Process Monitor
MSC Pre Process Worker
Planning ODS Load
Planning ODS Load Worker
MSC Pre Process Worker (MSCPPW) Performance
we found a performance in long running "MSC Pre Process Worker" for small data in staging.
it seems like 'MSC Pre Process Worker', 'Pre-Process Monitor' not drop temporary index after complete request.
example script to drop temp index for workaround solution