Post reply

FTP job taking longer

  • April 5, 2016 at 1:24 pm

    #315283

    Hello,

    So we have 1 server in east coast and other in TX rackspace.

    We have around 2 GB zipped db backup sitting in TX.

    I have FTP job running through SSIS in east coast which uses FTP server of TX to bring this 2 GB file from TX to east coast. It takes 20 mins to transfer 2 GB.

    Now We use the same process in TX to send this file from TX to east coast and we use the same FTP server thats in TX and then it took 3 hours to transfer 200 MB.

    Note that in TX we have more powerful server in terms of RAM,hard disk still it takes so much time.

    What could be the reason?

    Thanks.

  • April 5, 2016 at 1:33 pm

    #1869978

    dallas13 (4/5/2016)

    Hello,

    So we have 1 server in east coast and other in TX rackspace.

    We have around 2 GB zipped db backup sitting in TX.

    I have FTP job running through SSIS in east coast which uses FTP server of TX to bring this 2 GB file from TX to east coast. It takes 20 mins to transfer 2 GB.

    Now We use the same process in TX to send this file from TX to east coast and we use the same FTP server thats in TX and then it took 3 hours to transfer 200 MB.

    Note that in TX we have more powerful server in terms of RAM,hard disk still it takes so much time.

    What could be the reason?

    Thanks.

    I would guess at a difference between available upload and download speeds. Server power is generally not a factor when looking at FTP speeds, it's all about the connections.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • April 5, 2016 at 1:39 pm

    #1869984

    Thanks but is there any command to find upload\download speed somehow?

  • April 5, 2016 at 1:59 pm

    #1869989

    dallas13 (4/5/2016)

    Thanks but is there any command to find upload\download speed somehow?

    I am assuming that your FTP is running over the Internet. Try running this[/url] test, from both servers. Should provide some useful background information.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • April 5, 2016 at 3:05 pm

    #1870005

    I've used https://www.speakeasy.net/ for years and love it. However, any one will work.

    Like Phil said, it's all about connections. Your internet speed is a factor, but so is the speed of the server you're connecting to. You don't get any control over their bandwidth.

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply