Post reply

Importing data with SQL Management Studio remotely vs locally

  • March 22, 2010 at 2:22 pm

    #220185

    Why does it take longer (about ten times more) to import data from a flat file source to a database using Management Studio locally than when doing a remote session to the database server (the flat file is also there) and running Management studio at the server?

  • March 22, 2010 at 2:55 pm

    #1137853

    When you're local the whole file needs to come over the network to your local box and then back again across the network to be inserted into the database. When you log in remotely to the server and do it there, the only thing coming across the network is the data for your graphic display and the commands you perform.

    └> bt


    Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

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