Performance Issue migrating BLOB data from one database to another

  • I'm working on a consolidation of 2 databases into one.  One of the larger tables has 6 BLOB columns (text, varchar(max), nvarchar(max)) and takes an unacceptable amount of time to migrate in testing.  This table has about 10% of the rows to move and takes over 80% of the migration time in testing.  The only thing I can think of that is making the migration of this table so slow is the presence of these BLOB columns.  Does anyone have any suggestions as to how to more quickly move this data?  The databases are on one server and the process is just an INSERT INTO SELECT FROM.  I am doing it in batches.

    Thanks

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • Probably a good idea to first talk about what kind of time quantity vs row quantity we're talking about, as well as the hardware info, and in particular, the speed of the I/O path, including any/all subcomponents thereof (e.g. in a SAN, the speed of the SAN fabric and whether or not it's multi-pathed).

    Steve?(aka sgmunson)?:) 🙂 :)?
    Health & Nutrition
    Make Guaranteed Income

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

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