Skip to Content

awfully slow DTW import(update) Item Master

Hi,

When trying to import off business hours DTW is really slow, takes about 2 seconds a record importing pricelists , and / or , item's data frgnname + SuppCatNo.

trying to import about ~2000 records a time.

database size is ~ 30 gb.

SAP server is running on dual xeons , windows server 2008 , 96gb ram, sql resides on raid 5 4xSSD 256GB with raid battery controller.

network is 4gb/sec LACP.

thanks for any heads up,

NC.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Oct 27, 2012 at 01:19 AM

    Hi Nadav Caridi...

    This is related to system response time & it is not related to DTW or SAP B1.

    You may boost overall system performance by upgrading its RAM if you want to do DTW in single shot.

    When you do DTW, you had better select the non-working time. DTW may need more system resource than your current one.

    If possible, split the records may also help.

    Hope helpful 😊

    Regards

    Kennedy

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 29, 2012 at 08:42 AM

    Hi Nadav,

    Your hardware specs are way above recommended. so you do not have to worry about those (although I would recommend against RAID 5, as it is not optimal for database use, and would suggest using RAID 1).

    Have you tested importing smaller batches, of say 100 records, just to see if it makes a difference ? Also have you tested running the DTW directly on the B1 server ?

    Another thing you can test is the B1 client's own import-from-Excel tool. With such a simple import (only frgnname and SuppCatNo), it should suffice.

    Regards,

    Johan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 16, 2012 at 05:06 PM

    Hi,

    We have the same problem but only during the migration related with Items. The reason is that in our scenario the client had 50 warehouses and 25000 items. That makes 25000 x 50... a gigantic number of records.

    Are you migrating or updating Item master data?

    Regards.

    Rosa

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.