MySQL Bugs: #91426: export option take a long time to complete.

Bug #91426	export option take a long time to complete.
Submitted:	26 Jun 2018 18:06	Modified:	28 Jun 2018 6:56
Reporter:	Sylvain Lanteigne	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench	Severity:	S5 (Performance)
Version:	6.3.10	OS:	Windows (Microsoft Windows 10 Pro)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
Hi.

overall, the application work fine, only bug that is very affecting my work is on the export portion, i often have to export activity logs from our database witch contains more then 100k row.

doing so it can take Workbench from 2 to 5 minutes to execute that task. During that period, workbench act like it's crashing (showing not responding).

I looked at the log file and there is no related errors to this behavior.

How to repeat:
Export results to any format (csv, xml)

Thank you for the bug report. Please try version development release 8.0.11 rc. 
https://dev.mysql.com/downloads/workbench/

Hi.

suggestion was to download the dev version 8.0.11 rc.

i did, the export has improved but still take a long time, now between 1 to 2 minute for 100 k row instead of 2 to 5.

i was on windows 7 and i never had that issue, it's only since they switched me to windows 10.

if i use SQL developper, it take at max 20 sec. to save the file.

keep me posted and let me know if you need more details.

thank you.

Hi.

correction on the last reply,

After rebooting my pc, i ran another test to export a result of 100k rows X 9 columns to an excel .xml format and still took me around 3+ minutes.

Thank you for your time on this investigation.

Have a great day.

Hello Sylvain Lanteigne,

Thank you for the bug report.
This is most likely duplicate of Bug #86143, please see Bug #86143

Thanks,
Chiranjeevi.