record (row) counts

[expired user #3657]'s profile image [expired user #3657] posted 10 years ago in General Permalink
I Love Heidi, but one thing that is very distracting is that it does not seem to be able to count records (rows) accurately and consistently, I often copy tables for backup before processing against them, the record count inflates on the copy.. I don't have much confidence in other record counts eg updated etc.. The table summary view is pretty useless for record count

The record display says something like "xx records approximately..." This is a computer can we get accurate record counts???

I use record counts as a cross check that things are doing what they are supposed to do but it is very challenging with Heidi!
jfalch's profile image jfalch posted 10 years ago Permalink
you are probably using InnoDB tables. Row counts provided by the InnoDb engine as metadata are estimates, but fast; it is possible to obtain an exact rowcount (select count(*) from), but this is much slower. That´s why heidisql uses the inexact but fast rowcount in this one case.

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