Performance : Inserting into the Message Results tab should be done in blocks at a time.
If you execute a script with many INSERT statements with only Grid Results, it takes alot of time because of the Messages Tab.
I think the Message Results tab having a Text Editor might have been a bad initial choice from a performance perspective. I think we should chance the the contents of the Message Results tab from a Text Editor to a Grid like the "Script Details".
Can you take a shot at designing an implementing a Messages Grid Results?
See QueryPanel._queryResultMessagePane & _scriptDetailView, AFScriptContext.getTextResults() and QueryThread:Line1132.
Maybe you can implement a AFScriptContext.getGridTextResults() so we can compare.
I change the behavior so that the "Script Details" are now shown in the Messages Results.
I removed the Show Script Details action from the menu and toolbar.
SVN Rev #:28887
I change the behavior so that the "Script Details" are now shown in the Messages Results.
I removed the Show Script Details action from the menu and toolbar.
SVN Rev #:28887
Verified in 12.0.0-beta-47. Tested with 25000 inserts and compared to V11 is much faster and Messages in Grid Results are displayed without delay
Verified in 12.0.0-beta-47. Tested with 25000 inserts and compared to V11 is much faster and Messages in Grid Results are displayed without delay
Issue #7134 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build 12.0.0-beta-47 |
| No time estimate |
I think the Message Results tab having a Text Editor might have been a bad initial choice from a performance perspective. I think we should chance the the contents of the Message Results tab from a Text Editor to a Grid like the "Script Details".
Can you take a shot at designing an implementing a Messages Grid Results?
See QueryPanel._queryResultMessagePane & _scriptDetailView, AFScriptContext.getTextResults() and QueryThread:Line1132.
Maybe you can implement a AFScriptContext.getGridTextResults() so we can compare.