Recent changes to 1676: (ok 4.5) Link to get real row counts of all the views in a db, at once

#1676 (ok 4.5) Link to get real row counts of all the views in a db, at once

2015-06-01T04:35:50.438000Z

summary: Link to get real row counts of all the views in a db, at once --> (ok 4.5) Link to get real row counts of all the views in a db, at once
status: open --> resolved
assigned_to: Madhura Jayaratne

#1676 Link to get real row counts of all the views in a db, at once

2015-06-01T02:48:14.931000Z

Hi,

Looking at the code, I now realized that this is sort of bug.

If the last item of the tables and views listing has approx rows, the Total Count is clickable.

Made the changes and opened a new PR : https://github.com/phpmyadmin/phpmyadmin/pull/1710

#1676 Link to get real row counts of all the views in a db, at once

2015-06-01T01:58:59.463000Z

I think for consistency we should make the total count clickable when there is at least one table/view with approximate row count and fetch the real values on clicking it. I haven't looked at the code, but I think the current logic is such that total count is clickable where all the tables/views have approximate row counts, so changing it shouldn't be hard.

#1676 Link to get real row counts of all the views in a db, at once

2015-05-31T18:02:41.431000Z

PR : https://github.com/phpmyadmin/phpmyadmin/pull/1709

#1676 Link to get real row counts of all the views in a db, at once

2015-05-31T17:47:24.096000Z

The feature already exists.

Clicking on the 'Total Rows' fetches all the real row counts.

#1676 Link to get real row counts of all the views in a db, at once

2015-05-31T17:19:59.695000Z

Working on it.

Link to get real row counts of all the views in a db, at once

2015-05-31T17:19:27.546000Z

Hi,

The Db structure.php should provide an option to fetch all the Real Row counts (for views at once).

The placement of the link can be next to the 'With Selected:' div below the tables and views listing.

Should we include a icon for this or a simple link, like shown in the screenshot attached, is enough ?

(ok 4.5) Link to get real row counts of all the views in a db, at once

2015-05-31T17:19:27.546000Z

Ticket 1676 has been modified: (ok 4.5) Link to get real row counts of all the views in a db, at once
Edited By: Madhura Jayaratne (madhuracj)
Summary updated: u'Link to get real row counts of all the views in a db, at once' => u'(ok 4.5) Link to get real row counts of all the views in a db, at once'
Status updated: u'open' => u'resolved'
Owner updated: None => u'madhuracj'