Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

7
  • i have few doubts, 1. do I need to increase the timeout time of the MySQL connection or my c# transaction scope connection? 2. there are lot other query are executing in same c# transaction scope, Is t possible to read and insert in the same c# transaction scope? Commented Jul 11, 2016 at 10:59
  • Hi, I've seen that you dont' accept answers so with respect I'll leave my answer "as is" and repeat that it is my honest best recommendation for most efficient import into MySQL. Be Well :) Commented Jul 11, 2016 at 11:03
  • sorry, @Barry i am newbie to these processes. Commented Jul 11, 2016 at 12:43
  • 1
    in terms of your questions, I'm not sure about both... the timeout would depend on the size and duration it takes to import... the ability to read and write within the same transaction would be expected... this is just a MySQL command and MySQL commands are designed to be wrapped in transactions... but I've done neither of the above... I use this from PHP not C#... I just know that this is... by far... the fasted import to MySQL so I would advise to find a way to work with it Commented Jul 11, 2016 at 12:56
  • 1
    @Berry, thanks, it worked really well, now i am able to insert more than 100k records in just 1.5 to 2 seconds which was taking more than 40-45 seconds. Commented Jul 24, 2016 at 17:24