September 8, 2017 at 12:47 pm
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
September 8, 2017 at 12:55 pm
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) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply