WISHLIST ITEM: count of rows in the user interface

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

The count of rows does mention "approximately", but until now my max table size was around 450k+ and the count was always an exact match to the number of rows.

Could you please make the row count an exact number? it only took 0.36 seconds to count 1.53M rows, so surely it won't impact performance that much.

Many thanks, Gaetano.

ansgar's profile image ansgar posted 3 years ago Permalink

Getting the exact number of rows can be a performance killer on databases with many InnoDB tables. HeidiSQL retrieves the row count from a meta query, either SELECT .. FROM IS.tables or SHOW TABLE STATUS. Both return an estimated row count for InnoDB tables:

https://mariadb.com/kb/en/innodb-limitations/#table-status

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