All.
It has been a while since I programmed in VB, I have a program that needs to process and input file.
I am reading the input text file fine, and getting the database updated but it is extremely slow.
I was using tableadapters and bindingsources to update the data, but it takes about 30-40 minutes process the file. What is the best way to update a database in .net?
This is a catalog file (they send the whole catalog each time not just updates, and is about 22000 items) and I need to look at the new csv file and then either update or add the record to the database.
I have the import process down...it is just working really slow. The database is on the local drive but will be moved to a network server during deployment.
Any help/advice would be greatly appreciated.
It has been a while since I programmed in VB, I have a program that needs to process and input file.
I am reading the input text file fine, and getting the database updated but it is extremely slow.
I was using tableadapters and bindingsources to update the data, but it takes about 30-40 minutes process the file. What is the best way to update a database in .net?
This is a catalog file (they send the whole catalog each time not just updates, and is about 22000 items) and I need to look at the new csv file and then either update or add the record to the database.
I have the import process down...it is just working really slow. The database is on the local drive but will be moved to a network server during deployment.
Any help/advice would be greatly appreciated.