ODBC Destination to MySQL Bulk Insert
106 views
Skip to first unread message
David Botzenhart
Apr 23, 2012, 3:53:46 PM4/23/12
to CozyRoc
Hi,
I'm attempting to insert 600K rows to MySQL using the MySQL 5.1
Connector/ODBC driver and I want the ODBC Destination task to use the
Bulk Insert, but it doesn't seem to be using it. How do I configure
the ODBC Destination to use Bulk Insert?
The MyODBC log file has individual Inserts for each row.
Thank you for any help,
David Botzenhart
I'm attempting to insert 600K rows to MySQL using the MySQL 5.1
Connector/ODBC driver and I want the ODBC Destination task to use the
Bulk Insert, but it doesn't seem to be using it. How do I configure
the ODBC Destination to use Bulk Insert?
The MyODBC log file has individual Inserts for each row.
Thank you for any help,
David Botzenhart
Ivan Peev
Apr 27, 2012, 10:59:39 AM4/27/12
to coz...@googlegroups.com
Hi David,
To configure CozyRoc ODBC Destination component to use bulk-insert you have to specify for BatchSize parameter value greater than 1. The default value for the parameter is 10000.
Ivan
Reply all
Reply to author
Forward
0 new messages