export ResultSet without quering DB?

[whitehat]

Is it possible to export ResultSet without extra quering DB?
I have very slow queries (up to 60 minutes) and have to wait twice to export data into CSV....

[Serge]

Currently is is not possible.
I can suggest some kind of workaround - if your query may work faster when you fetch just a few rows then you may set fetch size to, say, 20 rows (500 rows by default - see text field in main toolbar), execute query and then use export function.
I'll think about possibility of executing queries directly to external file instead of result set grid. Not sure about UI..

Thanks

[whitehat]

OK. Hope You will add an option to export ResultSet directly from current results... Most of my queries do not produce much data, but take too long time to complete....

[Serge]

If you have not very big resultset (which fits into fetch size) then you may use workaround:
you may copy entire content of grid into clipboard (CTRL-A + CTRL-C) then paste clipboard into spreadsheet (MS Excel or Open Office Calc) and then save spreadsheet as CSV file. Not so convinient but should work.

[whitehat]

Just wanted to write about this workaround
Thank You for support