TablePlus-Windows icon indicating copy to clipboard operation
TablePlus-Windows copied to clipboard

Windows version laggy when scrolling vertically or horizontally

Open yawhide opened this issue 4 years ago • 14 comments

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.

yawhide avatar May 12 '21 15:05 yawhide

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)

tobiasreinhard avatar May 21 '21 14:05 tobiasreinhard

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.

Dragory avatar Jun 04 '21 08:06 Dragory

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.

KBulmer avatar Oct 05 '21 06:10 KBulmer

@huyphams how is the custom grid view coming along?

yawhide avatar Oct 05 '21 13:10 yawhide

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

ridwanpratama avatar Oct 07 '21 03:10 ridwanpratama

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.

plo009 avatar Dec 12 '21 07:12 plo009

+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.

eruptivpaul avatar Mar 09 '22 17:03 eruptivpaul

+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).

Zalerinian avatar Apr 14 '22 19:04 Zalerinian

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

lesmo avatar Jun 26 '22 08:06 lesmo