Bug #88557 Workbench becomes extremly slow with a SQL script with DOS line endings
Submitted: 20 Nov 2017 12:59 Modified: 20 Nov 2017 13:18
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:6.3.10 OS:Any
Assigned to: CPU Architecture:Any

[20 Nov 2017 12:59] Daniël van Eeden 
Description:
Opening a script with "\n" line endings (UNIX style) is much faster than opening the same script but with "\r\n" line endings (MS-DOS style)

How to repeat:
See attached files.
[20 Nov 2017 13:00] Daniël van Eeden 
File with UNIX line endings

Attachment: wb_inlist.sql (application/sql, text), 1.42 MiB.
[20 Nov 2017 13:01] Daniël van Eeden 
file with MS-DOS line endinges (I did use unix2dos)

Attachment: wb_inlist2.sql (application/sql, text), 1.61 MiB.
[20 Nov 2017 13:05] Daniël van Eeden 
This is on Fedora 27 x86_64
[20 Nov 2017 13:13] Daniël van Eeden 
This is just for opening the script, not for executing it.
[20 Nov 2017 13:18] Umesh Shastry 
Hello Daniël,

Thank you for the report.
I quickly tried on Win7 with provided .sql files and observed that noticeable slowness when DOS line endings file is opened.

Thanks,
Umesh