Hi all,
We have database files that have considerable amount of data. We have a routine that packs the tables of the database by looping thru the list of tables, use it exclusively then issue a PACK command. Note that all files are on my local drive. This is running the program from VFP8 IDE.
This is the behavior I'm noticing:
1. First round of PACK. Takes some time. This is understandable because VFP will actually cleanup the deleted rows.
2. Second round of PACK. It seems to hang on several table, no rhyme or reason. During this round, it 'hanged' for approx 5 minutes on a table with 1 row. I noticed my HD is trashing.
3. Third round of PACK. It 'hanged' for approx 5 minutes on a table with 1 million plus rows. I noticed my HD is trashing.
Am I missing something here?
nDbfs=adir(myDbfs,'dbf')
for nDbf = 1 to nDbfs
use (myDbfs[nDbf,1]) exclusive
PACK
use
endfor
ramil
~~ learning to stand still