Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

WISHLIST ITEM: count of rows in the user interface

Gaetano's profile image Gaetano posted 3 weeks 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 weeks 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.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.