Improve Performance - Invoke-DatabaseBuild - By removing powershell progressbar
I have discovered that too much information is being processed to simply display a percentage completed with the Invoke-DatabaseBuild command. I suspect other SQL Change Automation powershell commands are also utilizating the same behavior.
By turning the powershell progressbar off via the ps setting.
$ProgressPreference = "SilentlyContinue"
I improved a single database build performance:
From: 4 minutes -> To: 37 seconds.
I suspect there's alot of data serialization and deserialization taking place within SQL Change Automation update progressbar code to do a simple progressbar reporting update.
This code within sql change automation needs to be looked at more closely to improve the performance.
At minimum a flag on all SCA powershell commands that utilize the progressbar should be made available to disable it.
![](https://secure.gravatar.com/avatar/556f637913cc55725bacb4922cd2ca62?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
maxschafintact commented
this is awesome and reduced our db build times from 26 to 9 minutes! Please have a closer look into it.