Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Memo file too large
Message
 
 
À
07/04/2011 10:28:05
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Divers
Thread ID:
01506357
Message ID:
01506372
Vues:
70
>>>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--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform