Results preview for running query
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
Menu
▾
▴
#450 Results preview for running query
I'm doing some troubleshooting over a WAN, and a long-running query can take quite a while to complete. This is somewhat painful because Squirrel does not display results until the query is completed.
It would be nice to have a "Preview" button next to the "Cancel" button once data rows start being received; it would open a read-only grid of the latest 5 (configurable?) rows received from the server. This would allow a quick taste of the returned data before the full result set is received and displayed in the result grid, rather than having to wait tens of minutes (or longer) for the results.
Sorry, that should read "a long running query that returns a large result set". The network latency in shipping the results across the WAN has a much greater impact in this situation than the inherent complexity (and thus basic runtime) of the query.
Ath the Session Properties => JDBC, we have a property called "Fetch Rows at once" (fetchSize for JDBC). This property should enable the JDBC driver to handle a large result set by a more efficient way. But this is only a hint for the JDBC driver. At least, it works for Oracle.
For more information, please have a look at http://webmoli.com/2009/02/01/jdbc-performance-tuning-with-optimal-fetch-size.
For my WAN Connection, it solved my performance issues. Maybe it will help you to read your large result set in a shorter time. Please try it out and give us feedback. Thx
It's an interesting idea, so I am going to upvote it.
Although my feature request #468 would be enough for 99% of my issues ;-)