Re: Need Help deleting record from text file
- From: David Kerber <ns_dkerber@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 26 Sep 2007 10:32:52 -0400
In article <OfiA1aEAIHA.4476@xxxxxxxxxxxxxxxxxxxx>, nobody@xxxxxxxxxxx
says...
"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.
And a .mdb is not usually considered "a proper database", though for
many applications it's perfectly adequate. For the OP's application an
Access .mdb, or dBase .dbf's would likely serve just fine.
--
Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).
.
- Follow-Ups:
- Re: Need Help deleting record from text file
- From: Norm
- Re: Need Help deleting record from text file
- References:
- Need Help deleting record from text file
- From: Norm
- Re: Need Help deleting record from text file
- From: Dave O.
- Need Help deleting record from text file
- Prev by Date: Re: Need Help deleting record from text file
- Next by Date: Re: Loop without Do
- Previous by thread: Re: Need Help deleting record from text file
- Next by thread: Re: Need Help deleting record from text file
- Index(es):
Relevant Pages
|