search

TablePlus / TablePlus-Windows

TablePlus Windows issue tracker
https://tableplus.com
186 stars 3 forks source link

LibSQL is incredibly slow #660

Open Xexr opened 6 months ago

Xexr commented 6 months ago

Please answer the questions below, it helps us to track the issue.

  1. Which driver are you using and version of it (Ex: PostgreSQL 10.0): LibSQL

  2. Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81): Version 5.9.6 (270)

  3. The steps to reproduce this issue: Connect to a LibSQL database (I'm using Turso). All queries take 3-4 seconds to complete, everything feels very sluggish

Xexr commented 5 months ago

Hey, any thoughts on this? Many thanks

sonswift commented 5 months ago

Hi @Xexr, thank you for your feedback. However, I don't understand what you mean by the application being slow? It might be due to the connection to the Turso being slow, so the results might take more time.

Xexr commented 5 months ago

Hi @sonswift, thanks for the reply.

When accessing a turso libsql database, tableplus is incredibly so to read and write data. The blue loading bar at the top of the screen takes seconds to process for each action.

I've tried other databases (mysql, postgres) and tableplus is super fast for those. I don't believe its my connection, I have Gbit fibre, a low latency connection to the db (sub 20ms) and no other connection type issues.

Here's a recording showing you how slow it is:

https://github.com/TablePlus/TablePlus-Windows/assets/4774624/549368fe-0ff9-4597-81b9-585e96431127

Here's the same database in dataflare, you'll see its instant:

https://github.com/TablePlus/TablePlus-Windows/assets/4774624/fa6d5b47-01ad-40bc-9489-aa82dfb673cf

Thanks for your help

Xexr commented 5 months ago

Any thoughts on this @sonswift

The recent update doesn't appear to have resolved this.

wldbest commented 2 months ago

Please update the driver, TablePlus can not save row with vector column in Turso.