Comments
Sort by recent activity
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...
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
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...
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...
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.