MySQL Bugs: #67717: Queries that have a large result set perform badly in the result view window.

Bug #67717	Queries that have a large result set perform badly in the result view window.
Submitted:	26 Nov 2012 22:48	Modified:	29 Jun 2013 20:37
Reporter:	George Dombrowski	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S2 (Serious)
Version:	5.2.47	OS:	MacOS (Darwin 12.2.1)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
Large result sets of 1000 rows x 650 variables essentially freeze the results view window as well as the 
Mac OS-X MySQL Workbench Tool, version mysql-workbench-gpl-5.2.44-osx-i686.

 This does not happen with the Windows version of MySQL Workbench.

----- Developer Notes -----

MySQL Workbench CE for Mac OS X version 5.2.44  revision 9933
Configuration Directory: /Users/gdombrow/Library/Application Support/MySQL/Workbench
Data Directory: /Applications/MySQLWorkbench.app/Contents/Resources
Cairo Version: 1.9.1
OS: Darwin 12.2.1
CPU: 8x Intel(R) Core(TM) i7-3820QM CPU @ 2.70GHz, 16.0 GB RAM

How to repeat:
Easily repeated… happens every time!

I couldn't repeat with the below version, please try it.

MySQL Workbench CE for Mac OS X version 5.2.47  revision 10398
Configuration Directory: /Users/miguel/Library/Application Support/MySQL/Workbench
Data Directory: /Applications/MySQLWorkbench.app/Contents/Resources
Cairo Version: 1.9.1
OS: Darwin 12.2.1
CPU: 4x Intel(R) Core(TM) i5-3210M CPU @ 2.50GHz, 16.0 GB RAM

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

This is still a problem.

Do not close this ticket. I ran a comparison test today between the MySQL Workbench version 5.2.45 on Mac OS-X and version 5.2.47 CE on Windows-XP on my laptop's VM. The Windows version of Workbench 5.2.47 works just fine with 600+ variables whereas the Mac version freezes quite badly... having to force quit in order to recover control of the Workbench software. The same query was used to the same database for both tests above.

I will see if I can locate a more recent Mac OS-X version and to try again.

Thanks.

I have now installed the most recent 5.2.47 Workbench on Mac OS 10.8.3 Server and the problem still persists. I've even tried the query the same large table (>600 variables) using and updated MySQL server, Server version: 5.5.30 MySQL Community Server (GPL), and still the problem within the MySQL Browser persists. It is not easy to scroll across the variable. Although, if you keep the number of returned rows to a small number, it can be done... but it is painstakingly slow. 

One Windows XP all is fine and fast.

Please fix as I'm having to run a VM under Mac OS 10.8.3 just for the MySQL Workbench.

Thanks.

Duplicate of bug #69613