Improving the performance of a db import process
- by mmr
I have a program in Microsoft Access that processes text and also inserts data in MySQL database. This operation takes 30 mins or less to finished.
I translated it into VB.NET and it takes 2 hours to finish.
The program goes like this:
A text file contains individual swipe from a corresponding person,
it contains their id, time and date of…