KB3063513 - Warehouse management on-hand entries cleanup

(1) Share

Report

Posted on by cowboyott

204

We have been having some performance issues with queries against the inventSum and whsInventReserve tables. I found and installed the KB3063513 hotfix in a test environment, however the cleanup is extremely slow. We have 5 million records in both the inventSum and whsInventReserve table that could be cleaned up. The on-hand entries cleanup job takes almost 5 seconds per record to delete due to checking the reservation hierarchy to see there are any reservations against that location. After running for 4 days straight, it only cleaned up 60k records. At this rate, it could take up to a year to clean up the entire 5 million records.

Has anyone had any success using this job? Any ideas how to make it run faster?

Thanks!

I have the same question (0)

All responses (1)

Answers (0)

cowboyott 204 on at

Like (0)

Report
Copy link

Link copied!

Has anyone cleaned up WHSInventReserve entries directly from SQL?

Was this reply helpful? Yes No