search

TablePlus / TablePlus-Windows

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

Windows version laggy when scrolling vertically or horizontally #401

Open yawhide opened 3 years ago

yawhide commented 3 years ago

I am on a desktop with a decent desktop cpu. When I scroll vertically or horizontally, it lags super hard. I dont remember seeing this when using this product on a macbook air with a WAYYY less powerful cpu.

I tried lowering the number of rows to automatically load from 300 to 40 and it still lags. The cpu from task manager goes from 0.5% to about 20% when I continuously scroll.

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

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

  3. The steps to reproduce this issue: Use the product on a windows 10 machine.

tobiasreinhard commented 3 years ago

Can confirm that, downloaded/installed the latest version on Windows 10 today.

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

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

  3. The steps to reproduce this issue: Open a large database on a Windows 10 Machine (our table has 50+ columns)

Dragory commented 3 years ago

Also confirming this and tested a few things in an attempt to help pinpoint the cause:

  1. Which driver are you using and version of it (Ex: PostgreSQL 10.0): MariaDB 10.5 / MySQL 8.0

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

  3. The steps to reproduce this issue: Open a table with lots of columns and rows and try to scroll the data horizontally and/or vertically. The degraded performance is most obvious when dragging the scroll handles quickly, e.g. to quickly get to the last column or row in the table, though it's also noticable when just using the scroll wheel.

    The issue seems to get worse as more cells are displayed on the screen. I tested with a table with 15 columns and 30 rows and started experiencing degraded performance, while with a table with 1 column and 1000 rows performance was fine. Likewise, a table with 15 columns but only 5 rows was perfectly fine.

KBulmer commented 3 years ago

Still present in version 180. The larger the table and the faster you scroll, the harder it lags. Regularly getting 1 fps on a modern machine.

yawhide commented 3 years ago

@huyphams how is the custom grid view coming along?

ridwanpratama commented 3 years ago

Still present in build 180, it laggy and make my cpu usage went up when scrolling in a table with many column

plo009 commented 2 years ago

I do hope this problem could be fixed, it is a problem known by the devs for over a year. I haven't renewed my subscription mainly due to this reason.

eruptivpaul commented 2 years ago

+1 for this.

On a table with only 20 cols and scrolling horizontally is horrendously slow. It makes me want to use a different product.

It doesn't seem to be related to the number of rows, as by limiting my results to just 50 the problem is still there.

This is on an i9 10900K, so would hate to imagine how it is on slower chips.

Edit: This has been a problem on Windows 10 and 11 for me.

Zalerinian commented 2 years ago

+1 for this myself. Just purchased my license and am experiencing laggy horizontal scrolling especially on a table. I'm not seeing much uptick in CPU usage on scrolling, but I am seeing it on my GPU.

I'm running an AMD Ryzen 9 5900X 12-core processor with an older GTX 1060 3GB running TablePlus, which should be plenty sufficient. I'm running the latest version - TablePlus 4.9.1 x64 (Build 190).

lesmo commented 2 years ago

I'm also not renewing my license until this issue gets resolved.

huyphams commented 10 months ago

Hi guys, this is our last patch for this year, https://www.dropbox.com/scl/fi/hqi17lg3wrg74deuqxpmb/TablePlusUpdate.exe?rlkey=ap8at4ntmuw4wpgas4b46797y&dl=0

We made some improvements that can reduce lag when you select rows on data-grid when the right-sidebar is opened.

If you have a chance, please try it. We will focus more on performance on 2024. Happy new year!

Zalerinian commented 10 months ago

Hi guys, this is our last patch for this year, https://www.dropbox.com/scl/fi/hqi17lg3wrg74deuqxpmb/TablePlusUpdate.exe?rlkey=ap8at4ntmuw4wpgas4b46797y&dl=0

Hi Henry, thanks for the update. My license has expired so I'm no longer eligible to install updates through TablePlus itself. Will this updater cause a licensing issue if I were to use it?

huyphams commented 10 months ago

Yes, it likely will rollback to the free version @Zalerinian

axelthat commented 7 months ago

Same issue. Fluid smooth on Mac but seriously laggy on Windows. Both horizontal and vertical.

pavlo-mais commented 2 months ago

Still present on Build 276