Newer versions of Multi Script are really slow at saving results

Koll

Creating a new discussion as it's probably the best.
The performance on saving results are really slow when comparing and old version. Please read below.

To test performance I chose to download the AdventureWorks.bacpac file from below and imported it to a Azure SQL Server: https://github.com/MicrosoftLearning/dp-300-database-administrator/blob/master/Instructions/Templates/AdventureWorks.bacpac

I then found something that would give some data output in the sample database and chose these two simple queries:

SELECT * FROM [Sales].[vIndividualCustomer]

SELECT * FROM [Sales].[vPersonDemographics]

They return about 18508 and 19972 rows.

I then tried with latest Multi Script (1.5.32) and compared with the older version (1.5.7) where the saving results worked fast. The times are:

1.5.32: 2 minutes and 45 seconds
1.5.7: 13 seconds

So the old version is 12-13 times faster?  ::bandaged head:

I'm using these Multi Script Application Options, if it matters:


And the PC is in the better end:


Hope above can help further debugging. I'm back to running 1.5.7 as I need to save large outputs in the near future.

Koll

Tested latest 1.6.2 version of Multi Script, at the above takes: 2 mins and 37 seconds.
So still 12 times slower than version 1.5.7. Reverting again here. 

Any possibility that there can be looked into this?

sinkee

additionally on 1.6.2 version of multiscript I noticed that only 1 user can have multiscript opened at a time.

We have shared VM environment where multiple users (with multiple redgate licenses) are using multiscript at same time.

With version 1.5. it was working normally, now only 1 of us can have it opened.