# ERP Nightly Batch Job Parallelism and Runtime Calculator > Source: https://netray.co/tools/erp-nightly-batch-job-parallelism-runtime-calculator > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Find how many parallel threads shorten your ERP nightly batch, and when contention starts to make it slower. ## Category erp-operations ## Audience - ERP administrator - ERP developer - Batch scheduler ## Tool **Kind:** calculator **Inputs:** #### Single-thread runtime **Key:** total_hours **Type:** number **Default:** 8 **Min:** 0.1 **Step:** 0.5 **Unit:** hours **Help:** How long the batch runs with one thread or one worker. #### Serial share of the work **Key:** serial_pct **Type:** slider **Default:** 15 **Min:** 0 **Max:** 100 **Step:** 1 **Unit:** % **Help:** Steps that cannot be split: initial load, locking steps, final posting, file generation. #### Parallel threads **Key:** threads **Type:** slider **Default:** 8 **Min:** 1 **Max:** 32 **Step:** 1 **Unit:** threads **Help:** Batch servers, processes, MRP workers or job streams. #### Contention per extra thread **Key:** overhead_pct **Type:** number **Default:** 2 **Min:** 0 **Max:** 20 **Step:** 0.5 **Unit:** % **Help:** Lock waits, I/O queueing and coordination, per additional thread. #### Batch window available **Key:** window_hours **Type:** number **Default:** 5 **Min:** 0.5 **Step:** 0.5 **Unit:** hours **Outputs:** #### Serial fraction **Key:** s **Expr:** serial_pct / 100 **Format:** decimal #### Ideal runtime (no contention) **Key:** ideal_hours **Expr:** total_hours * (s + (1 - s) / threads) **Format:** hours **Description:** Amdahl's law. #### Expected runtime **Key:** runtime_hours **Expr:** ideal_hours * (1 + overhead_pct / 100 * (threads - 1)) **Format:** hours **Primary:** true #### Speedup **Key:** speedup **Expr:** total_hours / runtime_hours **Format:** decimal #### Parallel efficiency **Key:** efficiency_pct **Expr:** speedup / threads * 100 **Format:** percent #### Theoretical maximum speedup **Key:** max_speedup **Expr:** 1 / s **Format:** decimal **Description:** Upper limit with infinite threads and no contention. #### Headroom in the window **Key:** headroom_hours **Expr:** window_hours - runtime_hours **Format:** hours **Primary:** true **Description:** Negative means you miss the window. **Chart:** #### Batch runtime (hours) versus parallel threads **Type:** line **X:** threads **From:** 1 **To:** 32 **Steps:** 32 **Series:** - runtime_hours **Disclaimer:** A two-parameter model for planning. Measure real runtime at two or three thread counts and fit the serial share and contention to your results before changing production schedules. ## Content **Intro:** Adding threads to a nightly ERP batch helps until the serial part and contention take over. This calculator applies Amdahl's law with a contention term to show the expected runtime, the point of diminishing returns and whether you fit your batch window. **Sections:** #### How to use it **Body:** Enter how long the batch takes on a single worker, and the share that must run serially: initial selection, single-threaded posting, locking steps, final reports. If you are unsure, run the job at two thread counts and solve for the serial share. Add a small contention percentage for each extra thread, which represents locks and shared storage. Then compare the expected runtime and headroom against your window and see the curve on the chart. **Bullets:** - Measure the serial share from real runs, not guesses - Treat contention as the cost of each extra thread - Watch the minimum point on the chart #### The formula **Body:** Amdahl's law says runtime equals single-thread time times the serial fraction plus the parallel fraction divided by threads. With a serial share of 15 percent, even infinite threads cap the speedup at about 6.7 times. The contention term multiplies the result by one plus the overhead per extra thread, which makes the curve turn upward past some thread count. That turning point is the useful limit for your environment. #### Worked example **Body:** An 8 hour single-thread batch with a 15 percent serial share and 2 percent contention per thread, run on 8 threads, has an ideal runtime of 1.8 hours. Contention raises it to about 2.1 hours, a 3.8 times speedup at 48 percent efficiency. Going to 16 threads gives a worse result near 2.2 hours, because contention outweighs the parallel gain. Reducing the serial share is worth more than adding threads. #### Common mistakes **Body:** Teams add servers without checking that the database or the lock manager is the real bottleneck. Another is splitting work unevenly so one thread runs far longer than the rest, which behaves like a larger serial share. Check how the job divides work, for example by site, warehouse or item range, and balance the streams. **Cta:** If your batch window keeps slipping, we can profile the job chain read-only and show which steps are serial or blocking. **Faq:** #### What serial share should I assume? **Answer:** Start with 10 to 20 percent for typical ERP batch chains and then measure. Time the job at one and four threads, and solve Amdahl's law for the serial fraction. The measured figure beats any default, and it changes after tuning or data growth. #### Why does adding threads make it slower? **Answer:** Extra threads compete for locks, I/O, memory and the database log. Past a certain point the coordination cost outweighs the extra processing. The chart shows this as a curve that bottoms out and rises again. #### Is this valid for MRP and costing runs? **Answer:** It is a good first model for any job that can be split by key range, such as MRP by level, costing by site or posting by company. Jobs with strict dependency chains behave like a larger serial share. #### How do I reduce the serial share? **Answer:** Move preparation and cleanup steps out of the critical path, replace single-row loops with set-based work, split final posting by company or ledger, and run reports after the window. Each removed serial minute is worth more than adding a thread. ## Search terms batch job runtime calculator, amdahl law calculator, erp nightly batch window, parallel batch threads erp, mrp run time parallel, batch window too long erp, how many threads for batch job --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json