Yes, with some testing it is the INSERT that is slowing it down... A LOT.
Without the insert the file with 30,000 records gets read within 5 minutes.
Yes the quotes are always present.
Is there no faster way to INSERT records from a text file to the database?
--- In nsbasic...@yahoogroups.com,
Hi again,
I also noticed you have this in the loop "txtrecords.Text = i".
I assume you are writing the line record into a TextBox to display on the
screen the progress of reading the file.
You should take this out of the loop as it will definetely slow down the read
time. In each loop, setti
Hi,
Are you sure that reading the file is the slowest part.
I would think that performing the INSERT to the database would be slowest part.
The use of "Split" may be a slow function call.
Can you guarentee the quotes are all ways present, if so you may be able to use
the "Mid" function to st