invm
The performance of large databases is poor.
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.
Interesting, can you tell me approximately how many columns on average? Probably something to do with the sidebar rendering
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.
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.
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.
Sorry to only address this issue now, I released version 2.0.0, where I changed to editor to monaco editor, which should improve performance. I'll close the issue, feel free to reopen if the need arises.