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

6 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
  • Koll

    Still no update on this? I just tried the latest again and it's insanely slow compared to the old version. 

    We paid for multiple Red Gate Toolbelts licenses in our company, and there's like no support/response here?

    Koll
    1
  • Koll

    Still the same issue, as I tried the latest update (1.6.11.4199). Seems like isn't much support on this product? The program itself is better, but the save all is just so painfully slow compared to the old version. It can't really be used for larger outputs.

     

    Redgate are you there?

    Koll
    0

Add comment

Please sign in to leave a comment.