XP Machine blows an index

[529 Enterprises]

I have a client running a peer2peer network with machines running everything
from Win2k to XP_Sp2 and a dB IV app that has run reliably (with minor
glitches) for over 15 years. Within the last three days, one machine has
suddenly decided to blow up during indexing. The machine is a 3+/- GHz with
512mb memory running XP sp2 (sorry, I don't know additional details). Two
master tables having 60k+ records work fine during a reindex, but the detail
file (160k records) suddenly crashes during reindexing. I ran the same
process programatically 4-5 times last night and reindexed manually twice
from a tablet PC running Windows Tablet XP (or whatever its callled) and
everything worked fine. Several other machines in the office, including the
Win2k machines, pass the indexing fine. The tablet PC also has 512mb
memory, consistently had less available memory (according to task manager)
during the indexing process than the problem machine, but processed with no
problems. The command to reindex the detail file is:

Use DetFile
Pack

It uses two simple index keys in an MDX file, and this machine worked fine
on it until about two or three days ago. Physical memory has been swapped
and tested, the hard drive has been tested and I am stumped as to what has
happened. Any input, WAGs or other ideas welcome.

DR Berry

[Rainald]

I'm rather sure that is just a problem with the *speed*. The machine in
question is just too fast.

Which version of dB IV is thsi about?
There were serious versioons wit the eeraly version.

I can not recommend to run anything below dBIV 2.0 on modern equipment.
And I would urgently suggest to go for dB-DOS 5.0.

Rainald

Post by 529 Enterprises
I have a client running a peer2peer network with machines running
everything from Win2k to XP_Sp2 and a dB IV app that has run
reliably (with minor glitches) for over 15 years. Within the last
three days, one machine has suddenly decided to blow up during
indexing. The machine is a 3+/- GHz with 512mb memory running XP
sp2 (sorry, I don't know additional details). Two master tables
having 60k+ records work fine during a reindex, but the detail file
(160k records) suddenly crashes during reindexing. I ran the same
process programatically 4-5 times last night and reindexed manually
twice from a tablet PC running Windows Tablet XP (or whatever its
callled) and everything worked fine. Several other machines in the
office, including the Win2k machines, pass the indexing fine. The
tablet PC also has 512mb memory, consistently had less available
memory (according to task manager) during the indexing process than
the problem machine, but processed with no problems. The command
Use DetFile
Pack
It uses two simple index keys in an MDX file, and this machine
worked fine on it until about two or three days ago. Physical
memory has been swapped and tested, the hard drive has been tested
and I am stumped as to what has happened. Any input, WAGs or other
ideas welcome.
DR Berry

[Michael Nuwer]

Rainald wrote:

Hello Rainald,

It's good to see you here. I hope all is well with you.

Michael Nuwer

[Rainald]

Post by Michael Nuwer
Hello Rainald,
It's good to see you here. I hope all is well with you.
Michael Nuwer

Thank you so much for the welcome!

I have not been working with dBASE for quite some looong time, but I'm
planning to start again.

Hope all is well with you and your work too.

Kindest regards
Rainald