Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Urgent : Memo file too big
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01172279
Message ID:
01172296
Vues:
17
>>>I have an urgent problem to solve.
>>>
>>>On of my customer have e memo file that reached 2Go, seems to be corrupted because this size is abnormal (2 097 152 Ko)
>>>
>>>I can't open it with VFP9, even if the TABLEVALIDATE is set to 0...
>>>
>>>Any idea on how to recover this memo file is welcome (there is 10 people that can't work)
>>
>>Can you send me this DBF (and all related files) ZIPped of course, to see what can I do. Don't expect much I am not sure I could do something.
>
>Thanks, but I used a small utility (CDBF Viewer) that solve my problem. It open ed the DBF, and I used it's pack function. After 3 hours, the .FPT file shrink from 2.097.152 Ko to 64.308 Ko. That's fine, but I have no idea why this FPT grew so fast until that size.

That is so called Memo file bloat. Every time you replace something in the MEMO VFP creates new records in FPT file and set the poiner to it. I suggest you to add some maintaining routine that USE the files EXCLUSIVE, PACK, PACK MEMO and REINDEX them.
That routine could be runner sometime when no users works, maybe after midnight.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform