I use the .NET connector from MySql. And when I use the MySqlCommandBuilder to do insert in my table, it seems to run quite slow. I have a little mor than 1000 rows to insert at one time. Yet it takes approx. two minutes do finish the inserts. This seems quite slow to me.

Any ideas on how I can get the execution faster??

why not insert several rows at once?

instead of this --

insert into mytable (col1, col2, ... colN) values ('val1', val2, ... 'valN')
insert into mytable (col1, col2, ... colN) values ('val1', val2, ... 'valN')
insert into mytable (col1, col2, ... colN) values ('val1', val2, ... 'valN')
insert into mytable (col1, col2, ... colN) values ('val1', val2, ... 'valN')
...

try this --

insert into mytable (col1, col2, ... colN)
values ('val1', val2, ... 'valN')
, ('val1', val2, ... 'valN')
, ('val1', val2, ... 'valN')
, ('val1', val2, ... 'valN')
...