Analysis of the migrations showed that the bulk of the time was spent upserting the document after it was mutated in the Migration/SqlMigration/DocumentMigration/DataMigration's Map method. Changes have been made to improve the performance of the DocumentOperations.PerformTask method to reduce the bottleneck.
Ideally we would have used the bulk executor library for this, but issues with dependencies render it's use too challenging.
Analysis of the migrations showed that the bulk of the time was spent upserting the document after it was mutated in the Migration/SqlMigration/DocumentMigration/DataMigration's Map method. Changes have been made to improve the performance of the DocumentOperations.PerformTask method to reduce the bottleneck.
Ideally we would have used the bulk executor library for this, but issues with dependencies render it's use too challenging.