Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Urgent : Memo file too big
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01172279
Message ID:
01172296
Views:
16
>>>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform