Tables and sql editor rendering super slow on relative lots of rows or lines.

[YindSoft]

I've just bought TablePlus butI'm experimenting really slow UI performance when the table have a few thousand rows.. like it's super slow, the same thing if the SQL is too long, it will get super slow the editor. Plus it's super annoying if I need to copy data from the table to an excel the only way seems to be exporting.. I can just select a few rows and copy all data in a simple way like DBeaver for example. Is there any solution for this?

Thanks.

[rmcamps]

Have the same problem. Comparing to others Mysql Client Software, is very slow when querying tables with TEXT columns with huge data. Also it lacks an automatic LIMIT on SQL SELECT queries. It´s a problem when you forgot to put LIMIT querying a table with lots of rows.

[huyphams]

Hi @rmcamps did you enable the auto limit?

[rmcamps]

Thank you! The autolimit could be ON by default.

[huyphams]

it's trade off so if we enable it, there will be users who don't want it to be enabled by default.

[YindSoft]

Even if it's not.. there is no reason if there is 100.000 rows in the table to be slow.. there are thousand of tables that can render that without issue as it done in memory, the issue is with the way the system renders the table

[marc-nds]

Hi @rmcamps did you enable the auto limit?

I don't see this option on Windows (Trial)?

[sonswift]

Hi @marcvanbreemen, which database are you using? We don't support "Auto row limit" for ClickHouse, SQL Server, Mongo DB and Redis.

[marc-nds]

Hi @marcvanbreemen, which database are you using? We don't support "Auto row limit" for ClickHouse, SQL Server, Mongo DB and Redis.

Using MSSQL.

[sonswift]

Hi @marcvanbreemen, which database are you using? We don't support "Auto row limit" for ClickHouse, SQL Server, Mongo DB and Redis.

Using MSSQL.

Thanks, this feature is currently not supported with MSSQL.