LS Retail data director - Performance issues

abnainas
abnainas Member Posts: 174
edited 2009-11-16 in NAV/Navision Classic Client
Dear All,

Kindly we encounter a problem in NAV 5.1 LS Retail when we make a replication between the Head Office and the Store. The Head office and the Store are located in different areas and they are connected using ADSL 1MB speed. But when we run the replication, the system take a long time. I just want to ask if IMB ADSL is sufficient for such case. and what is the recommended ADSL speed in such case.

Please Advice.
Ahmad Bani Naser
Dynamics NAV Developer

Comments

  • ara3n
    ara3n Member Posts: 9,258
    how much data are you replicating?

    Data director can run on dialup, and it has good compression, it just depends on how much data you are replicating.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • abnainas
    abnainas Member Posts: 174
    Dear ara3n,

    We add a 60 new Items and change price for 200 Items daily.

    It take a 50 Min to accomplish the replication.

    Please advice
    Ahmad Bani Naser
    Dynamics NAV Developer
  • ara3n
    ara3n Member Posts: 9,258
    How have you setup replicate for those tables?
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • David_Singleton
    David_Singleton Member Posts: 5,479
    Also what is your internet speed?
    David Singleton
  • anilkumar
    anilkumar Member Posts: 136
    We add a 60 new Items and change price for 200 Items daily.
    It take a 50 Min to accomplish the replication.

    As per my experience DD won't take that much time to replicate those records.

    Which Data Director version you are using??

    may be problem with your DD setup/DD not configured properly or you are using CFront.
    Anil Kumar Korada
    Technical Consultant
  • abnainas
    abnainas Member Posts: 174
    DD version :2.26.7 and using CFront
    Internet speed : 1Mb
    All tables replicate using By Action Method

    Please see the attached doc.

    Thanks in advance
    Ahmad Bani Naser
    Dynamics NAV Developer
  • abnainas
    abnainas Member Posts: 174
    Please see the attached pic's
    Ahmad Bani Naser
    Dynamics NAV Developer
  • anilkumar
    anilkumar Member Posts: 136
    As per the screen shots, Store Distribution location you are using DD_HO,

    can I know How many DD services you created??

    HO - DD service??
    Store - DD service??

    or using same DD service ??
    Anil Kumar Korada
    Technical Consultant
  • David_Singleton
    David_Singleton Member Posts: 5,479
    abnainas wrote:
    Internet speed : 1Mb
    ...

    Are you sure? How do you know?
    David Singleton
  • ahmad_dev
    ahmad_dev Member Posts: 2
    anilkumar wrote:
    As per the screen shots, Store Distribution location you are using DD_HO,

    can I know How many DD services you created??

    HO - DD service??
    Store - DD service??

    or using same DD service ??


    two service one for Head office and one for store.
  • ahmad_dev
    ahmad_dev Member Posts: 2
    David Singleton wrote:
    abnainas wrote:
    Internet speed : 1Mb
    ...

    Are you sure? How do you know?

    yes,from internet provider
  • David_Singleton
    David_Singleton Member Posts: 5,479
    ahmad_dev wrote:
    David Singleton wrote:
    abnainas wrote:
    Internet speed : 1Mb
    ...

    Are you sure? How do you know?

    yes,from internet provider


    sorry to be the one to break this to you, but quite possibly they "lied". As do all ISPs. Basically as soon as you said 1meg it looked odd. Had you said 940k or 1,081k I would think differently, but in cases like this it looks like just a label.

    Go to this site

    http://www.dslreports.com/speedtest?flash=1 and pick a site and run the test.

    You will get a result something like the attached image.



    You can see that my download speed is 1289k and my upload is 420k BUT the internet connection I pay for is an 8meg ADSL. So as you can see they are not really telling the truth.

    Now the first number is irrelevant, the important one for your situation uploading the file is the second number (UPLOAD SPEED) what do you get for that?

    PS I assume you realize you must run this program at the STORE site where you are SENDING the data from, not on your Main server.
    David Singleton
  • David_Singleton
    David_Singleton Member Posts: 5,479
    OH and run the test during normal business hours when you normally do the upload.
    David Singleton
  • anilkumar
    anilkumar Member Posts: 136
    two service one for Head office and one for store.

    But as per screenshots you are using same DD_HO for both HO and store due to that this much of time it is taking.

    change the DD service in store to store DD service only, and the same changes update in hosts files in HO and store.

    then try to replication and check the speed.
    Anil Kumar Korada
    Technical Consultant

Categories