Feedback: query exact row count from tables and views

paul's profile image paul posted 3 years ago in General Permalink

Hi, I like to use the nightly builds and noticed this new feature. I would like to suggest making this an option that can be switched off (if it is already, I can't find it)

It can take several seconds to perform COUNT(*) on some very large tables (100 million rows+) and I don't really mind if the row count is approximate.

Thanks!

ansgar's profile image ansgar posted 3 years ago Permalink

I marked that modification "experimental", as I already expected issues with large tables. I chould indeed make it optional, and by default turned off. But it's probably the best to revert that modification, as this was anyway more a cosmetic change.

Code modification/commit 28d25e3 from Ansgar Becker <anse@heidisql.com>, 3 years ago, revision 11.3.0.6313
Revert a144466e7137f1c33c39c231dbeb4cd98dfc4ffa : query exact row count from tables and views. See https://www.heidisql.com/forum.php?t=37983
sky2k4's profile image sky2k4 posted 3 years ago Permalink

Thanks for reverting it - best to make it optional.

Please login to leave a reply, or register at first.