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 re开发者_如何学编程cords 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
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!
精彩评论