Hello,
HeidiSQL does not count correctly the rows of tables, much to update (f5) does not give the correct result.
Another problem I have is that after making a large query increases RAM consumption and the end is not released.
Greetings!
Failed to count rows and more
Counting rows in a large database can be an expensive operation that can take a lot of time to complete. That's why HeidiSQL does not even attempt to do it; it simply shows the estimation provided by the server.
If phpMyAdmin really does it I'd say it's a bug rather than a feature. But, most likely, you're now working against a local server where table engine defaults to InnoDB. If your tables are MyISAM, then the row count should be exact.
If phpMyAdmin really does it I'd say it's a bug rather than a feature. But, most likely, you're now working against a local server where table engine defaults to InnoDB. If your tables are MyISAM, then the row count should be exact.
Thanks for your comment kalvaro. This happens to work locally and remotely, and no matter how big the table, I'm talking about a table with 1000 rows, and has no count exact rows. And if I use InnoDB. I have not really tested MyISAM ... Thanks for the help.
The other theme of the RAM is there any solution?
The other theme of the RAM is there any solution?
There is another complaint about huge RAM usage here. Please starr that issue.
Please login to leave a reply, or register at first.