record (row) counts

User, date Message
Written by Dartdog
4 weeks ago
Category: General
6 posts since Wed, 20 Aug 08
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!
Written by jfalchMoney, Euro
3 weeks ago
383 posts since Sat, 17 Oct 09
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.