Page 1 of 1

export ResultSet without quering DB?

PostPosted: Tue Aug 07, 2012 3:15 pm
by 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....

Re: export ResultSet without quering DB?

PostPosted: Wed Aug 08, 2012 2:19 pm
by 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

Re: export ResultSet without quering DB?

PostPosted: Fri Aug 10, 2012 10:16 am
by 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....

Re: export ResultSet without quering DB?

PostPosted: Fri Aug 10, 2012 10:34 am
by 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.

Re: export ResultSet without quering DB?

PostPosted: Fri Aug 10, 2012 11:19 am
by whitehat
Just wanted to write about this workaround :)
Thank You for support :)