Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo file too large
Message
 
 
To
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:
01506372
Views:
69
>>>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.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform