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.
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 :)