Home » DbVisualizer Forums » DbVisualizer » DbVisualizer - Feature Requests

Thread: Max Rows Per Connection


Permlink Replies: 4 - Pages: 1 - Last Post: Jan 14, 2012 5:41 PM Last Post By: Levi Stanley
Matthias Bergk

Posts: 10
Registered: 02/25/10
Max Rows Per Connection
Posted: Sep 24, 2010 9:13 AM
   thread.click_reply Reply
Dear Sirs,

I am working with "remote" (through Internet and VPN) servers as well as local servers.

Therefore I would like to set a high value of "Max Rows" on local connections, but
a much lower value for remote connections.

Kind regards,
Matthias Bergk
Roger Bjarevall


Posts: 5,120
Registered: 12/17/04
Re: Max Rows Per Connection
Posted: Sep 27, 2010 9:59 AM    global.in_response_to.tooltip in response to: Matthias Bergk
   thread.click_reply Reply
Matthias,

Thanks for your suggestion. I will register a ticket for it.

Best Regards

Roger
Levi Stanley

Posts: 31
Registered: 02/19/09
Re: Max Rows Per Connection
Posted: Jan 5, 2012 12:07 AM    global.in_response_to.tooltip in response to: Matthias Bergk
   thread.click_reply Reply
My request is on the lines of this as well, however, adding another layer to it. I usually connect to several databases as well, however since I am on devel alot, I usually set the rows to max, however, I sometimes wonder what the max rows are before I hit the data tab, sometimes I do have a limit of 100 or 1000 but sometimes it is set to devel setting and it makes a query of select * from table. Needless to say, it freezes up, and I have to kill the process, and if I don't kill the process on the DB, I get the DBA on me. Luckily, this has only happened on the slave and not master.

I set my production databases by selecting the type, however, it would be nice to have a dialog that checks with me the number of rows before it does the select on production connections. What would also be nice if you allowed it to be set in the dialog which will change the lower left setting in the window.
Roger Bjarevall


Posts: 5,120
Registered: 12/17/04
Re: Max Rows Per Connection
Posted: Jan 9, 2012 10:21 AM    global.in_response_to.tooltip in response to: Levi Stanley
   thread.click_reply Reply
Levi,

It sounds as if the "Max Rows at First Display" property match what you are requesting. At first display of the table data the specified number of rows will be fetched. Following reloads will fetch as many rows as specified in the Data tab Max Rows field.

Is this what you are looking for?

You find the setting in the General->Table Data category in Tool Properties.

Regards

Roger
Levi Stanley

Posts: 31
Registered: 02/19/09
Re: Max Rows Per Connection
Posted: Jan 14, 2012 5:41 PM    global.in_response_to.tooltip in response to: Roger Bjarevall
   thread.click_reply Reply
Ah, that will work nicely.

Point your RSS reader here for a feed of the latest messages in all forums