Bug #103774 Saving to MySQL 8.x using MySQL ODBC 8.0 Unicode driver is slow
Submitted: 21 May 2021 15:09 Modified: 30 Oct 2021 12:10
Reporter: Emil Trusca Email Updates:
Status: No Feedback Impact on me:
None 
Category:Connector / ODBC Severity:S5 (Performance)
Version:8.0.24 OS:Windows (Microsoft Windows Server 2019 Standard)
Assigned to: MySQL Verification Team CPU Architecture:Any
Tags: WBBugReporter

[21 May 2021 15:09] Emil Trusca
Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\etrusca\AppData\Roaming\MySQL\Workbench\log\wb.log]

Saving to MySQL 8.x using MySQL ODBC 8.0 Unicode driver is slow

How to repeat:
Just try to save a big model to MySQL Server version 8 using MySQL ODBC 8.0 Unicode driver 

Suggested fix:
the speed of save is 27 times worse than on Oracle server
[30 Sep 2021 12:10] MySQL Verification Team
Hello Emil Trusca,

Thank you for the bug report.
To investigate further this issue at our end, may I kindly request you to provide answers to below questions?

1. Did you try save a model without ODBC?
2. Have you tried to save the same db model in Oracle DB from Workbench?
3. Is ODBC tracing enabled? if yes then it should be disabled at once and it should be only used for debugging because of huge performance impact.

Regards,
Ashwini Patil
[1 Nov 2021 1:00] Bugs System
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".