Slow loading of tables

[Lawondyss]

Hi Fabio,

first of all, I want to thank you 🙇
I have been looking for such a client for a long time and the ongoing development gives me hope that in time it will satisfy all my requirements 👍

But what really bothers me is the table listing in the left menu. Selecting a DB will trigger a SHOW TABLE STATUS FROM... query, which for large DBs (tens and hundreds of GB) can take minutes! One of "my" DB vo has almost 20 GB and I have bigger ones.

Would it be possible to use the SHOW TABLES FROM... query and get the rest of the information in the background?

[Fabio286]

Hi Ladislav,

thank you very much for your appreciation!

Unfortunately I also have database with many tables and SHOW TABLE STATUS FROM is very slow.
Initially I adopted this strategy to get some metadata related to the tables. However, several things have changed in the core since then, so I will do a reevaluation for the implementation of SHOW TABLES FROM.

I will keep you updated!

[Fabio286]

Since some previously needed data are no longer I am testing the query:

SELECT
   TABLE_NAME,
   TABLE_TYPE,
   ENGINE,
   DATA_LENGTH,
   INDEX_LENGTH,
   TABLE_COMMENT,
   TABLE_COLLATION, 
   CREATE_TIME,
   UPDATE_TIME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'schemaname'

From my initial tests it seems to perform well and if I don't encounter any problems I will implement this change in the next release.

[Lawondyss]

I tried the query on one of the larger databases and it is still considerably slow. It must be because some of the columns are dynamic. From your query they are DATA_LENGTH, INDEX_LENGTH, CREATE_TIME and UPDATE_TIME. Without them, the query is super fast.

[Fabio286]

You are right, in my test environment even clearing mysql cache results fast but in other cases it does not.
I should be able to implement SHOW FULL TABLES FROM which also returns me the table type.
I think I will add an option to the settings to disable the table size calculation and in that case adopt the above query.

[Fabio286]

I'm implementing the option, off by default, to enable table size calculation on sidebar.
If this option is off Antares uses SHOW FULL TABLES FROM schema_name to get the table list.
You will find this feature in next release!

[Lawondyss]

I have the new version with improved tables loading and it's great 👍
Thanks for that 🙇‍♂️