Good Day Experts!
I have a Vb.Net application that I am trying to improve the processing speed. It takes too long to finish when many records in the textfile.
Currently I query the database checking for the keyed value before doing the insert if no duplicate. If I empty the database and take off the Duplicate check it is waaaay faster.
Is it possible to just execute the NonQuery insert...does the system return a distinct error message if keyed value found which I can check for and then bypass to the next record?
Thanks for your ideas,