#450 Results preview for running query

open
nobody
Core (98)
5
2012-12-29
2012-01-30
John Hardin
No

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.

Discussion

  • John Hardin

    John Hardin - 2012-01-30

    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.

     
  • Stefan Willinger

    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

     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks