Performance Improvement

maxschafintact

Hi,

I just needed to repost this here, because it is so awesome.

We use SCAPowershell and Invoke-DatabaseBuild is really slow. Turning off powershell progressbar speeds this up and gets our execution time from 26 minutes down to 9. This is a big deal.

$ProgressPreference = "SilentlyContinue"

This is an important finding. Performance was always the reason not going with Redgate Source Control, this changes a lot.

 orig: https://redgate.uservoice.com/forums/267000-sql-change-automation/suggestions/44882212-improve-performance-invoke-databasebuild-by-re 

Thanks.

EricLamontagne

Thank you very much maxschafintact!
I will try this, the performance was very annoying indeed!

Éric