Activity overview
Latest activity by Koll
Any one from Red Gate able to comment or check the Save All speed comparing the two versions? / comments
Any one from Red Gate able to comment or check the Save All speed comparing the two versions?
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? / comments
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 in...
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 A...
Moved my question to new thread: https://forum.red-gate.com/discussion/91094/newer-versions-of-multi-script-are-really-slow-at-saving-results/p1?new=1 / comments
Moved my question to new thread:https://forum.red-gate.com/discussion/91094/newer-versions-of-multi-script-are-really-slow-at-saving-results/p1?new=1
From my point of view, the newer versions are very slow at exporting in general. I had a large number of scripts (77) that I ran and exporting output in 1.5.7 works fine, I end up with a 123 MB file with 154 sheets (message and results per script). The results can be anything from a single column of nvarchar(256) to integers and dates. It can also be database nvarchar(max) columns, where data though aren't much, just bad database design, but still strings or sentences :-) With the newest version I also tried narrowing it down, like only running 5 or 10 scripts at a time, knowing I'd have a hassle with combining the Excel file. But this still crashed or too very long. / comments
From my point of view, the newer versions are very slow at exporting in general. I had a large number of scripts (77) that I ran and exporting output in 1.5.7 works fine, I end up with a 123 MB fil...
It's still not working as it did in v1.5.7. I tried v1.5.23 and can also crash with larger result sets where they work in v1.5.7. Application: SQLMultiScript.exe Framework Version: v4.0.30319 Description: The process was terminated due to an unhandled exception. Exception Info: System.Exception at SQLMultiScript.ResultsPanel.ExportAllData(System.String, SQLMultiScript.ScriptFetchState[], RedGate.SQLMultiScript.Engine.IJobEventArgs[], System.Collections.Generic.Dictionary`2<Int32,JobInfo>, System.Action, SaveAllCancellable, System.Threading.ManualResetEvent) at SQLMultiScript.ResultsPanel+<>c__DisplayClass102_4.<SaveAllTask>b__10(System.Object) at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean) at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean) at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem() at System.Threading.ThreadPoolWorkQueue.Dispatch() / comments
It's still not working as it did in v1.5.7.I tried v1.5.23 and can also crash with larger result sets where they work in v1.5.7.Application: SQLMultiScript.exeFramework Version: v4.0.30319Descripti...
Removed. / comments
Removed.
Removed.
/ comments
Removed.
Same issue, have to revert back to SSMS18 to use SQL Prompt. / comments
Same issue, have to revert back to SSMS18 to use SQL Prompt.
Same for me, not sure if it's some other software part or MultiScript. I can't seem to find any logs about why either. Reverting to the 1.5.7 that there is a direct link to above works. / comments
Same for me, not sure if it's some other software part or MultiScript. I can't seem to find any logs about why either.Reverting to the 1.5.7 that there is a direct link to above works.