Bug #77220 | MyODBC connector is VERY SLOW after 5.1.8 | ||
---|---|---|---|
Submitted: | 2 Jun 2015 7:56 | Modified: | 8 Apr 2019 10:26 |
Reporter: | Emmanuel KARTMANN | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | Connector / ODBC | Severity: | S5 (Performance) |
Version: | after 5.1.8 | OS: | Windows (Windows Server 2008/2012 R2) |
Assigned to: | CPU Architecture: | Any | |
Tags: | ODBC Connector Performance Regression |
If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.
To split a large file:
- On *nix platforms use the split command e.g.
split -b 50MB <my_large_archive> <my_split_archive_prefix>
- On windows use WinZip or a similar utility to split the large file
[5 Jun 2015 9:49]
Chiranjeevi Battula
[5 Jun 2015 13:07]
Emmanuel KARTMANN
Sample test file (need to have MyODBC 5.1.8 AND MyODBC 5.3.4 installed)
Attachment: myodbc_performance.js.zip (application/x-zip-compressed, text), 677 bytes.
[8 Apr 2019 10:30]
Emmanuel KARTMANN
Batch script to test connection performance with ODBC drivers
Attachment: myodbc_performance.js (application/x-javascript, text), 4.95 KiB.