export ResultSet without quering DB?

Feature requests and their debate

export ResultSet without quering DB?

Postby whitehat » Tue Aug 07, 2012 3:15 pm

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....
whitehat
 
Posts: 8
Joined: Fri Apr 27, 2012 9:05 am

Re: export ResultSet without quering DB?

Postby Serge » Wed Aug 08, 2012 2:19 pm

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
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: export ResultSet without quering DB?

Postby whitehat » Fri Aug 10, 2012 10:16 am

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....
whitehat
 
Posts: 8
Joined: Fri Apr 27, 2012 9:05 am

Re: export ResultSet without quering DB?

Postby Serge » Fri Aug 10, 2012 10:34 am

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.
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: export ResultSet without quering DB?

Postby whitehat » Fri Aug 10, 2012 11:19 am

Just wanted to write about this workaround :)
Thank You for support :)
whitehat
 
Posts: 8
Joined: Fri Apr 27, 2012 9:05 am


Return to Feature Requests



Who is online

Users browsing this forum: No registered users and 5 guests