Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo file too large
Message
From
07/04/2011 10:40:42
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01506357
Message ID:
01506375
Views:
68
>>>>I have a table that periodically needs a PACK MEMO on it to keep the FPT file from growing too large. Once packed, the size of the FPT shrinks from near the 2 GB limit to some few hundred MB in size.
>>>>
>>>>I let it go too long so today I have Error 41's trying to get it open to perform a pack. Any ideas on how to do that?
>>>
>>>You should look into why memo is growing so fast. Most likely it's result of to many updates on memo fields. Every time a memo field is updated, it's copied entirely to the end of FTP file (unless table is open exclusively).
>>
>>Sergey,
>>
>>do I understand that a memo file will overwrite old deleted code with new code if it is opened exclusive??
>>Regards,
>>
>
>It'll if it fits into the already allocated space otherwise it'll relocated to the end of the file.

Hmmm, interesting. Does this qualify even without a pack memo ?

Regards,

Koen
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform