Bug #89852 Slow Result Grid repaint
Submitted: 28 Feb 2018 15:10 Modified: 2 Jan 10:19
Reporter: Nicolas Martin Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S5 (Performance)
Version:6.3.10 OS:Microsoft Windows (7 SP1)
Assigned to: CPU Architecture:ARM
Tags: result grid slow refresh repaint

[28 Feb 2018 15:10] Nicolas Martin
Since a few versions (maybe a year?), the Result Grid is very slow to refresh (repaint).
When restoring window from task bar (maximizing),every time, takes 3 seconds to repaint 27 columns by 41 rows.
At first, every cell appear dark gray and then, one by one, appear white with value.

Even when trying to update, the grid takes some time to accept the change (it is apparently repainting the whole shown grid)

I'm using Dell Precision 5510 i7-6820 (8 cores) 2.70 GHz and 16 GB RAM
Current usage is: 14% CPU and 11.9 GB RAM
Even if I close everything and only open Workbench, it still happens.

How to repeat:
Clicking on the taskbar icon to minimize and clicking again to maximize (full screen 1920 x 1080), the 27 columns and 41 rows take approximately 3 seconds to repaint. It will occur every time I do it, even if it's done successively, without changing anything.
[28 Feb 2018 21:19] MySQL Verification Team
Thank you for the bug report. I couldn't repeat on 2 Windows machine, 1 linux and 1 MAC OS. So what I guess is issue on your environment. One of my Windows machines has the below info:

Configuration Directory: C:\Users\Miguel\AppData\Roaming\MySQL\Workbench
Data Directory: C:\Program Files\MySQL\MySQL Workbench 6.3 CE
Cairo Version: 1.10.2
OS: Microsoft Windows 10 Pro
CPU: 4x Intel(R) Core(TM) i7-7500U CPU @ 2.70GHz, 7.9 GiB RAM
Active video adapter Intel(R) HD Graphics 620
Installed video RAM: 1024 MB
Current video mode: 1920 x 1080 x 4294967296 colors
Used bit depth: 32
Driver version:
Installed display drivers: C:\WINDOWS\System32\DriverStore\FileRepository\ki119054.inf_amd64_0bc1ec00286be982\igdumdim64.dll,C:\WINDOWS\System32\DriverStore\FileRepository\ki119054.inf_amd64_0bc1ec00286be982\igd10iumd64.dll,C:\WINDOWS\System32\DriverStore\FileRepository\ki119054.inf_amd64_0bc1ec00286be982\igd10iumd64.dll,C:\WINDOWS\System32\DriverStore\FileRepository\ki119054.inf_amd64_0bc1ec00286be982\igd12umd64.dll
Current user language: English (United States)
[1 Jan 6:14] Ivan McA
Nicolas, I wonder if the monitor you have the window on is scaled to other than 100%. Particularly if it is scaled to a non-round multiple like 125%. I have very poor graphics performance from MySQL Workbench if it is on a scaled monitor. 100% is fine, 200% is slower but liveable with but 125% is terrible.
[2 Jan 10:19] Nicolas Martin
Hello, scaling is at 100%. Regards, Nick