Post reply

copying table with 1 billion rows ..

  • December 2, 2010 at 5:52 am

    #142762

    Hi,

    i have a table with 1 billion rows and i need to copy it to my mirror database ( both the source and destination are sql server 2005)

    And I'm trying with ssis to transfer it. But the dataflow task is taking around 1hr 30min

    I have OLEDB source and OLEDB Destination in the DataFlow task. No any other transformations.

    is there any to make it faster ???

    Thanks,

    Manoj

  • December 2, 2010 at 6:43 am

    #1257837

    Is that really slow? If its between servers on a network then thats not so bad. I just did a simple copy over my network on a 2GB file and that took about 3min. So in 90min that would be 60 GB. So it depends a bit on how big each row is in your table. 60B/row aint that much.

    Not that i have any solution to speeding this up. Just want to raise the question if it is really slow or maybe actually really fast... it could be ALOT of data after all.

    /T

  • December 2, 2010 at 7:06 am

    #1257854

    I am also interested to know what will happen to this table in future. Will it be maintained incrementally (via appropriate UPDATEs and INSERTs) - in which case is this just a one-off load?

    I'm assuming not, otherwise why bother posting?

    So ...why not? Is it a billion rows of new data every time?

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

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

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