[SOLVED] Execute and Export Resultset

Feature requests and their debate

[SOLVED] Execute and Export Resultset

Postby maslopo » Tue Jan 15, 2013 11:37 am

I usually elaborate queries that return millions of records and require a few minutes of processing ... I then repeat the process to export the result ... is there a way to perform such export immediately after the entire resultset with a single query execution?

Grazie.
Last edited by maslopo on Tue Feb 12, 2013 11:24 am, edited 1 time in total.
maslopo
 
Posts: 25
Joined: Fri Dec 28, 2012 4:17 pm

Re: Execute and Export Resultset

Postby Serge » Wed Jan 16, 2013 9:30 am

Generally when you execute a query result set viewer fetches only first N rows (200 by default). While export fetches entire resultset. So first time query should be executed relatively fast.
From the other hand some queries execution takes more time than data fetch and it is a problem.

So, we can add this feature in one of nearest versions.
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: Execute and Export Resultset

Postby maslopo » Thu Jan 17, 2013 12:45 pm

Perfect, some queries require a lot of processing time before returning rows ... so if it were possible to export them directly ... would be great ... thank you!
maslopo
 
Posts: 25
Joined: Fri Dec 28, 2012 4:17 pm


Return to Feature Requests



Who is online

Users browsing this forum: No registered users and 7 guests