Hi
Does someone out there knew how i can make my program upload an excel containing thousands of records in mySql in a faster way. Coz right now it takes 5 mins. or more just to upload 2000 records in mysql. I am using stored procedure to upload my data in mysql. any idea or reference would be much appreciated.
front end. vb.net
back end. MS sql 2008
Best Regards and Thank you in advance.
|