Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP 8 Pack behavior
Message
De
21/09/2005 12:25:09
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
01051684
Message ID:
01051693
Vues:
17
>Did you exclude VFP table files from virus scan?

Very good question. Indeed, the DBF files are NOT excluded from our viruscan. Thanks.

>
>>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?
>>
>>* pseudo-code
>>nDbfs=adir(myDbfs,'dbf')
>>for nDbf = 1 to nDbfs
>>  use (myDbfs[nDbf,1]) exclusive
>>  PACK
>>  use
>>endfor
>>
ramil
~~ learning to stand still
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform