Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo file too large
Message
From
07/04/2011 10:28:05
 
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:
01506371
Views:
67
>>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 content with new content if it the dbf is opened exclusive??
Regards,

Koen
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform