# DMT Processing Slow

**URL:** <https://www.epiusers.help/t/dmt-processing-slow/40827>\
**Category:** Epicor ERP 10\
**Created:** [October 12, 2017, 6:44pm UTC](https://www.epiusers.help/t/dmt-processing-slow/40827 "2017-10-12T18:44:38Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Randy](https://www.epiusers.help/user_avatar/www.epiusers.help/randy/32/51539_2.png) [@Randy](https://www.epiusers.help/u/Randy)\
**Post date:** [October 12, 2017, 6:44pm UTC](https://www.epiusers.help/t/dmt-processing-slow/40827/1 "2017-10-12T18:44:38Z")

</div>

We’ve been loading in open orders from our old ERP into 10.1 and it was running pretty fast at first. We have about 12k orders with a total of just over 16k releases to load. The rate of our OrderRel DMT is down to 2 records/min, it was near 25 when we first started.

With that many releases, we split it up into multiple DMT files to run one-at-a-time. The first files ran fast.

Is there any way to help speed up DMT?

---

<div class="post-metadata">

**Author:** ![asmar](https://www.epiusers.help/user_avatar/www.epiusers.help/asmar/32/4119_2.png) [@asmar](https://www.epiusers.help/u/asmar)\
**Post date:** [October 12, 2017, 6:57pm UTC](https://www.epiusers.help/t/dmt-processing-slow/40827/2 "2017-10-12T18:57:55Z")

</div>

One way is to make sure you don’t have unnecessary BPMs enabled during the data load. Sometime you need the BPMs to perform specific business process requirements. You also need to explore with your DBA any DB housekeeping SQL-Server maintenance jobs that maybe interfering with your data load. Last but not least, have you tried loading your data during non-prime time business hours?

Regards,

---

<div class="post-metadata">

**Author:** ![rdominguez](https://www.epiusers.help/letter_avatar_proxy/v4/letter/r/9d8465/32.png) [@rdominguez](https://www.epiusers.help/u/rdominguez)\
**Post date:** [October 12, 2017, 8:17pm UTC](https://www.epiusers.help/t/dmt-processing-slow/40827/3 "2017-10-12T20:17:02Z")

</div>

if you will run multiples DMT files at the same time you can run Multiple IIS process for your appserver too to balance the load.

Regards  
RD

---

<div class="post-metadata">

**Author:** ![Randy](https://www.epiusers.help/user_avatar/www.epiusers.help/randy/32/51539_2.png) [@Randy](https://www.epiusers.help/u/Randy)\
**Post date:** [October 12, 2017, 8:19pm UTC](https://www.epiusers.help/t/dmt-processing-slow/40827/4 "2017-10-12T20:19:19Z")

</div>

I did start it last night after hours, the first 2 batches ran at 25ish RPM and loaded within a few hours. I started last nights and it was still running this morning at 2 RPM. We stopped it but I even made a small 10row file and it still ran at 2 RPM. Hence my question.

Our DBA did mention a shrink of the index could help. There wasn’t any over-night maintenance plans other than a backup at 3am.

---

<div class="post-metadata">

**Author:** ![Edge](https://www.epiusers.help/letter_avatar_proxy/v4/letter/e/0ea827/32.png) [@Edge](https://www.epiusers.help/u/Edge)\
**Post date:** [October 13, 2017, 11:28am UTC](https://www.epiusers.help/t/dmt-processing-slow/40827/5 "2017-10-13T11:28:52Z")

</div>

Do you have ReadyToCalc on the header set to False for your orders - you should find that has a positive impact on the speed - details in the help on why (tax Calculations among others)

---

<div class="post-metadata">

**Author:** ![Randy](https://www.epiusers.help/user_avatar/www.epiusers.help/randy/32/51539_2.png) [@Randy](https://www.epiusers.help/u/Randy)\
**Post date:** [January 18, 2018, 9:39pm UTC](https://www.epiusers.help/t/dmt-processing-slow/40827/6 "2018-01-18T21:39:18Z")

</div>

Yes, I always set the ReatToCalc value in a separate DMT file as it slows DMTs down.

We just had a large number of orders with 2000+ releases that were slow to load via DMT.