Request suggestion

Hi Ansgar

A little request, I can leave without, but is so simple to implement.

Menu Tool-> Count registers or some where else

I knwow that when you click on a table you get a total number of rows, but it's not always accurate.

I write this post because I get a "138.896 rows total" when I click on the table, I know that's not possible then I make a Select count (*) that gives me 88423 which is the right value.

I suppose the 138.896 came from any sort of table information, but it's not accurate.

I am also conscient that we can not make a select count every time because it's time consuming on big tables, that's why I suggest a tools menu or context menu or even a "count all" icon near Next,show all" etc.

Thank you for your time an fantastic program.

Quite useful idea I think. I am pushing a change which adds a context menu to the data grid header, where you can query the exact row count:

The new exact row count will live in HeidiSQL's cache until you reload the database tree.

Is there a ticket in the tracker already for this?

Hi Ansgar Thanks for answering so quickly.

I've never done a ticket, don't know how it works or how to use it. Sorry.

Thank you.

Hi Angar,

I've just tested the release ans ome thing went wrong. The application crashes. I think there is a loop fectching the first 1000 registers.

SELECT FROM tza_registros.valores ORDER BY tag ASC LIMIT 1000; SHOW TABLE STATUS LIKE 'valores'; SELECT FROM tza_registros.valores ORDER BY tag ASC LIMIT 1000; SHOW TABLE STATUS LIKE 'valores'; SELECT FROM tza_registros.valores ORDER BY tag ASC LIMIT 1000; SHOW TABLE STATUS LIKE 'valores'; SELECT FROM tza_registros.valores ORDER BY tag ASC LIMIT 1000; SHOW TABLE STATUS LIKE 'valores'; SELECT FROM tza_registros.valores ORDER BY tag ASC LIMIT 1000; SHOW TABLE STATUS LIKE 'valores'; SELECT FROM tza_registros.valores ORDER BY tag ASC LIMIT 1000; SHOW TABLE STATUS LIKE 'valores'; SELECT FROM tza_registros.valores ORDER BY tag ASC LIMIT 1000; SHOW TABLE STATUS LIKE 'valores'; SELECT FROM tza_registros.valores ORDER BY tag ASC LIMIT 1000; SHOW TABLE STATUS LIKE 'valores'; SELECT FROM tza_registros.valores ORDER BY tag ASC LIMIT 1000; SHOW TABLE STATUS LIKE 'valores'; SELECT FROM tza_registros.valores ORDER BY tag ASC LIMIT 1000; SHOW TABLE STATUS LIKE 'valores'; SELECT FROM tza_registros.valores ORDER BY tag ASC LIMIT 1000; SHOW TABLE STATUS LIKE 'valores'; SELECT FROM tza_registros.valores ORDER BY tag ASC LIMIT 1000; SHOW TABLE STATUS LIKE 'valores'; SELECT FROM tza_registros.valores ORDER BY tag ASC LIMIT 1000; SHOW TABLE STATUS LIKE 'valores'; SELECT FROM tza_registros.valores ORDER BY tag ASC LIMIT 1000; SHOW TABLE STATUS LIKE 'valores'; SELECT FROM tza_registros.valores ORDER BY tag ASC LIMIT 1000; SHOW TABLE STATUS LIKE 'valores'; SELECT FROM tza_registros.valores ORDER BY tag ASC LIMIT 1000; SHOW TABLE STATUS LIKE 'valores'; SELECT * FROM tza_registros.valores ORDER BY tag ASC LIMIT 1000; SHOW TABLE STATUS LIKE 'valores';

and then a messageBox with an error indication

I don't know why my return lines are eliminated by the editor ??

I can't open the DATA tab after this update :/

Yes, there is a problem.

Yes, I forgot an important file in the first git commit. Should be fixed in the new build now.

Looks fine now! Thanks