The performance of large databases is poor.

[zhyipeng]

Env: MacOS 14.2 (23C64), M2, 32G
When opening a MySQL database with a very large number of tables (around 2000), the entire program experiences significant lag and is nearly unusable.

[invm]

Interesting, can you tell me approximately how many columns on average? Probably something to do with the sidebar rendering

[zhyipeng]

Interesting, can you tell me approximately how many columns on average? Probably something to do with the sidebar rendering

There are about 1,000 tables partitioned by date, each with 9 columns, and the other tables average less than 10 columns each.

[invm]

Hi there @zhyipeng, I've updated the tables and the views list to use a virtual list, can you check if this fixes your issue in 1.2.0?
You should get an update prompt.

[zhyipeng]

Hi there @zhyipeng, I've updated the tables and the views list to use a virtual list, can you check if this fixes your issue in 1.2.0?您好，我已经更新了表格和视图列表以使用虚拟列表，您能否检查一下这是否解决了您在 1.2.0 中的问题？ You should get an update prompt.您应该会收到更新提示。

Thx. I have tried the new version. The program's lag has improved significantly, but there is still lag when typing and deleting in the SQL editor.