Monday, February 21, 2011

Batch Insert with Mysql Connector for .NET

I was wondering if there is any Bulk Insert functionality available on the MySql Connector. I do have to create millions of records and I believe the batching will be a great feature for this.

I'm working on an MVC project with a MySql datastore.

Thanks, Leonardo

From stackoverflow
  • I haven't worked with .NET, but can you use the LOAD DATE INFILE-option in MySQL? It can do millions of records per minute, depending on your database hardware.

    Good luck!

    Homer1980ar : I was looking for something more programming related. But I will take your advice in case there is too slow.

0 comments:

Post a Comment