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

[Deven Bansod]

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 ?

[Deven Bansod]

Working on it.

[Deven Bansod]

This feature is already present in an inconsistent(atleast to me) way.

The Total rows in information_schema is clickable and fetches all real rows counts.

But in a db like sakila which has both tables and views, it is not clickable.

This rfe tries to add a uniform option of doing so.

[Deven Bansod]

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

[Madhura Jayaratne]

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.

[Deven Bansod]

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

[Madhura Jayaratne]

Fixed with https://github.com/devenbansod/phpmyadmin/commit/7c37657cc5e5a482e02856af2def93a4f7604fb0