How can we help you today? How can we help you today?

Newer versions of Multi Script are really slow at saving results

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
0

Comments

4 comments

Sort by
  • 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?
    Koll
    0
  • 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.
    sinkee
    0
  • Koll
    Any one from Red Gate able to comment or check the Save All speed comparing the two versions?
    Koll
    0
  • Koll

    Still running the old version. Would be nice if you could just try out the same scenario or similar and test it.

    Koll
    0

Add comment

Please sign in to leave a comment.