Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement