Expand Database node

Not sure where to log feature requests - please let me know if they need to go somewhere else.

When expanding a 'table' node in the server tree, several meta data queries are ran against the database:

SHOW TABLE STATUS FROM <db>;
SHOW FUNCTION STATUS WHERE `Db`=<db>;

etc...

Our server has several hundred database and this has started to take a lot of time to simply open the node of a database. Ideally, it would only run the query for 'Tables' when the tables node is opened, 'Functions' when expanding the 'Functions' node, etc... Thanks!

You can, for performance reasons, disable the checkbox "Fetch full table status" in the session manager. That way, HeidiSQL will only fetch basic columns, which is quite much faster than the normal approach.

If you then need the full table status again, you can click the drop down arrow on the green reload button in the main menu, and click "Get full table status", or simply press Shift+F5 instead of F5.

I am not able to find this option anywhere - can you send a screen shot?

Sorry - "Advanced" options in the session manager. Got it - you rock! Thanks!