Apologies if this option exists already but I was unable to find it anywhere.
I'm using DbVisualizer Pro 10.0.25 [Build #3025] and currently when I open a table DBViz will automatically apply the last filter that was used. If the filter is one that takes a considerable time to execute, I'm stuck waiting until it finishes. Otherwise I have to grapple with killing the connection, clearing the filter and then reconnecting before refreshing.
It would be great to have an option to use no filter on initial load, so that DBViz just uses the set max rows when first opening the table.
As far as I know, there is no such option in current version. I will register this as a feature request and we will look into it.
Thanks for taking the time to suggest this!
regards / Peer
I am jumping in here. There is the setting Max Rows at First Display in Tools->Tool Properties under the General / Data Tab category. It is used how many rows should be displayed when the Data tab is first displayed for a table. Setting it to 0 will not load any rows at all.
However, I believe setting it to 0 is still not a perfect fit for you as it will run the query but ignore getting any results.
Thanks for the suggestion Roger, I set the value to 0 but as you suspected DBViz still tries to apply the filter before returning 0 rows after the query has finished.
Just to inform you that we have just released a beta version of the upcoming DbVisualizer 11.0 with support to disable filters from being part of the SELECT if limiting number of rows in the Data tab at first display.
Download here: https://www.dbvis.com/beta/
You find the option in Tools->Tool Properties under the General / Table Data category.
I hope this is what you are looking for.
Hi Roger, that option worked perfectly. Thanks for the prompt fix!
Just to inform you that DbVisualizer 11.0 has been released.
In DbVisualizer open Help->Check for Update to run the upgrade or download from our web site.
Please let me know if I can be of further assistance with any questions you may have.