Bug #116134 MySQL Workbench 8 - Result Grid too slow to load and navigate.

• Submitted: 17 Sep 23:31
• Modified: 18 Sep 11:47
• Reporter: Rafael rzgons
• Status: Need Feedback
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 8.0.38
• OS: Windows (Microsoft Windows 11 Home Single Language)
• CPU Architecture: Any
• Tags: WBBugReporter

[17 Sep 23:31] Rafael rzgons

Description:
I just got a fresh new computer and installed MySQL Workbench, which I have been using daily for many years, always up to date, but now it seems to process Result Grid very badly.

When I execute a SELECT query, the results are not shown instantly in screen. Instead, it loads line by line, like if I was running it on a very old computer.  The action is already done (eg: 0.125 sec), but the Result Grid takes about 1 second to finish the listing. It also happens when I roll the scrollbar, resize the window or create new rows directly in Result Grid.

Look, I was using the same [i5 / 16GB RAM / 1GB GPU / Windows 10] computer for about 12 years, and now I got a [i7 / 32GB RAM / 8GB RTX4060 GPU / Windows 11].

How to repeat:
Just try to do anything when Result Grid is on screen.

[18 Sep 11:47] MySQL Verification Team

Hello Rafael rzgons,

Thank you for the report and feedback.
I have tried to reproduce this on MacOS with remote MySQL Server instance and fetching million rows - it took a while to fetch data but there was no issues observed while navigating rows by rows. Checked with a colleague of mine who was using Workbench on Windows 11 but no issues observed there as well.

To investigate further this issue at our end, may I kindly request you
to launch workbench under debug mode (--log-level=debug3) and provide
unaltered workbench log file(more details about log are explained here -
https://dev.mysql.com/doc/workbench/en/workbench-reporting-bugs.html) along with screenshot of the problem? Thank you.

regards,
Umesh