General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2008 Server
>>>>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only