troubleshooting Question

Fastest way to insert 8000 rows of data to MySQL

Avatar of AWestEng
AWestEngFlag for Sweden asked on
.NET ProgrammingVisual Basic.NETEditors IDEs
10 Comments1 Solution620 ViewsLast Modified:
Hi guys,, need your expert advice here. :)

I need some help here to figure out what I should do to make a fast insert..

 I have q question open here regaring batch update.
https://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_22713198.html

I need some advice what type of method I should use when inserting 8000 rows of data to my MySQL database.

What I have heard is that the DataAdpter is the fastest way to insert data to a MySQL table.

But when using dataadapter I got 6,5 sec and when using a loop that created 8000 querys where much faster 3,5 sec.

So now i'm confused,  which method should I use to get the best result :)

thx
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 10 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros