MySQL ODBC performance in SSIS
MySQL ODBC performance in SSIS
I tried using the MySQL odbc driver and found the performance incredibly slow when using the component in SSDT 2015 (This is SSIS). To be honest I found little difference between the MySQL odbc driver provided by Devart and the one provided by MySQL. Is there a setting I am missing or a better way to connect to MySQL?
Re: MySQL ODBC performance in SSIS
Please specify whether you are using our driver for importing and exporting data to MySQL.
In order to investigate the issue, please send to us scripts for creating and filling in the database object.
In order to investigate the issue, please send to us scripts for creating and filling in the database object.
Re: MySQL ODBC performance in SSIS
Sorry about that. I am importing data into MySQL. I am using the odbc driver from within SSIS (SSDT 2015) as an odbc destination component. The table being inserted into has 5 columns, one of which has an autoincrement on it. I am using batch mode (from within the SSIS component).
Re: MySQL ODBC performance in SSIS
We significantly improved the performance of Devart ODBC Driver for MySQL when working with SSIS and using batch mode. This improvement will be included in the next build of Devart ODBC Driver for MySQL.