Menu

#359 Make the number of rows returned more visible

closed
nobody
Core (98)
5
2009-09-01
2009-07-23
Anonymous
No

Row count is a very important information after executing a query. At the moment, this information is not easily available (I need to navigate to the Info tab).

Below three suggestions how to show the row count:
1.a) To show it in the status message panel (along with elapsed time).
E.g. "Query 1 of 1. Rows: 4322. Elapsed time (seconds) - Total: 25.25, SQL query: 1.39, Building output: 23.86."
1.b) To show it in the result set tab before the SQL command. E.g.
"Rows:12345. select * from Table"
1.c) To show it in the result set tab status bar (next to the alias)

Discussion

  • Eduard Manas

    Eduard Manas - 2009-07-30

    I think the cleanest solution is solution 1.b above.
    So, if when we are limiting the number of rows we see a message like
    "Limited to 100 rows; select * from table"
    Now, we will see the following message when either not row limit is set, or we return less rows than the limit:
    "Row Count: 1113; select * from table"

     
  • Gerd Wagner

    Gerd Wagner - 2009-09-01

    Fixed in CVS:
    Number of rows read is now visible on message panel and results tab.

     
  • Gerd Wagner

    Gerd Wagner - 2009-09-01
    • status: open --> closed
     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.