command window painfully slow with larger results

[Michael Virnstein]

When i query large tables and i get many lines back, the command window is painfully slowing down, the more lines it has to display. If i use the sql window instead, this is a lot faster and doesn't slow down very much on larger results.
The problem with the sql window is, that i can't use real bind variables varname) there. The variables (&varname) in the sql window are replaced with the actual content before the statement is executed. It would be nice, if the sql window would also support bind variables.

 

[Marco Kalter]

If you need bind variables, you can use the Test Window. It supports result sets in the same way as the SQL Window.

 

[Michael Virnstein]

Yes it does, but i can't export the result set from there. Binds in SQL Window would be nice, but what is really an issue is the performance of the command window. In version < 7 it was quite ok with larger results, but since 7.1 it is really slow.

 

[Marco Kalter]

I have added this to the list of enhancement requests.