search

TablePlus / TablePlus-Linux

TablePlus Linux issue tracker
https://tableplus.com
289 stars 30 forks source link

Running queries or viewing large tables freezes/crashes the application #194

Closed ipmanlk closed 4 months ago

ipmanlk commented 5 months ago

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

  1. Database version (Ex: PostgreSQL 10.0): PlanetScale (MySQL Driver)

  2. TablePlus version (the number on the welcome or about screen, Ex: build 81): 1.0.3 (238)

  3. Linux distro (Ex: Ubuntu 18.04): Manjaro Gnome

  4. The steps to reproduce this issue: Try querying or navigating a large table on PlanetScale.

I experienced this when working with a large PlanetScale database. Surprisingly enough this didn't happen with my local MySQL server. I believe UI is freezing due to slow network requests. Table I used for testing contained roughly 100k rows. I experienced brief UI freezes and some crashes occasional crashes when executing queries.

Issue, image

My current setup, image

huyphams commented 4 months ago

It doesn't crash; it's loading the rows on the main thread. You're loading too many rows, but with very low networking. Background threading in C is a bit challenging, so it's not the top priority at the moment, which means it will fail most stress tests with low network. By the way, even with very low network, a background thread doesn't help anyway.