Re: Need Help deleting record from text file


"Norm" <NormF4@xxxxxxxxxxxxxxxxx> wrote in message
news:Oj0kBrAAIHA.5980@xxxxxxxxxxxxxxxxxxxxxxx
I am working on a backup program that keeps a record of the original path
so that a backup file can be replaced.

I started out using two listbox's and then comparing them to each other,
but when the number of files goes over 2 thousand it gets very slow and I
have some that or over 10 thousand.

Is there a way of doing this faster?

Sure, use a proper indexed database rather than mucking about with flat
files and list boxes, a bit more code but it will run far faster and you
wont have resort to black magic to get good performance when the record
count gets to >10,000.

Regards
Dave O.

P.S. I've got an analysis program here using a simple Access MDB file with
over 600,000 records and though not instant the queries are adequately rapid
for our requirements, so as long as the critical fields are indexed a
piddling little 10,000 records should be very fast indeed.


.