Re: Need Help deleting record from text file

David Kerber wrote:
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.

Thanks to everyone, I now have a lot of other options to try and make work.

I had actually started on one close to what Larry is recommending and will
continue to play with it for now, but I will also look at the other ways of
making this work and hopefully come up with the easiest and fastest.

When I actually get something working I will post the code to see how it can
be improved.

Thanks again,

Norm

--
Norm

Don't blame me, my programming is
self-taught and my teacher was not
very experienced. :-)

normfowler_don't use_@xxxxxxxxxxx


.

Relevant Pages

  • Re: 0 Blocking, but lots o locks...can that be right?
    ... Access MDB can't handle such a large table. ... be 2 folks who wind up with many, many locks, while everyone else ... 1318 S key locaks, ...
    (microsoft.public.sqlserver)
  • Re: specify version of ms-access in Shl.Run?
    ... I hope the quoted path to msaccess.exe for the 10 version ... >association for Access *.MDB *.ADP files. ... >| various applications like a Microsoft Access mdb file. ... >| sht.run is calling the Access97 exe. ...
    (microsoft.public.scripting.vbscript)
  • Re: Need Help deleting record from text file
    ... use a proper indexed database rather than mucking about with flat ... 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 ...
    (microsoft.public.vb.general.discussion)
  • Re: Altering linked tables
    ... then recreate the link to the table. ... >> I am using an Access mdb with all linked tables in MSDE. ... so that I can alter them in the ADP. ...
    (microsoft.public.sqlserver.msde)
  • Re: Altering linked tables
    ... Will it affect all my forms and reports? ... >> I am using an Access mdb with all linked tables in MSDE. ... so that I can alter them in the ADP. ...
    (microsoft.public.sqlserver.msde)