How to fetch all rows for a single query?

Feature requests and their debate

How to fetch all rows for a single query?

Postby beat-x » Sun May 04, 2014 3:53 pm

There is a global fetch limit in DBeaver which stops fetching data after a certain amount of rows (I think the default is 200). When I scroll down, the next 200 rows are fetched, and so on.

This is a great feature, but sometimes I want to fetch all rows at once (without using the export feature). How do I do that? I know of 2 methods, but I don't think they are particularly user-friendly:
1. Clear the "maximum result-set size" field in the toolbar, execute your query, then set the remembered value in the field again.
2. Go to the result table and keep pressing Ctrl+End (which always fetches 200 rows more) until all rows are fetched.

Is there a better way? If no, please consider adding one. ;-) A button in the bottom bar named "fetch all rows" would be enough.
beat-x
 
Posts: 10
Joined: Sun Dec 02, 2012 4:32 pm

Re: How to fetch all rows for a single query?

Postby Serge » Mon May 05, 2014 5:33 pm

Hello,

I agree that such feature could be useful. But I'm not sure that adding extra button in toolbar is the best solution. Data view toolbar already has too many actions. Adding extra button on each feature will overcomplicate it very fast.
Maybe some toggle key (ALT?) would be better. So CTRL+ALT+END (or ALT+click on "Last Row" button) will fetch and scroll resultset to the very end.
WDYT?
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: How to fetch all rows for a single query?

Postby beat-x » Mon May 05, 2014 6:07 pm

You are right, maybe toggling an existing action would be the best solution. I like Ctrl+Alt+End. You could also (additionally) use Alt + "Refresh result set" button (this should be mentioned in the tooltip text tough). Another option would be the "Configure" popup menu, or the table context menu.
beat-x
 
Posts: 10
Joined: Sun Dec 02, 2012 4:32 pm


Return to Feature Requests



Who is online

Users browsing this forum: No registered users and 10 guests