Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Huge DBC
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00409138
Message ID:
00409262
Vues:
16
>Thats done the job - it's shrunk from 100Mb to 86Kb - How on Earth did it get that big in the first place?

I think the biggest reason is changing view definitions or configurations. These are stored in memo fields and each time you make a modification, the memo file will grows because it takes what you just modified and appends it to the end of the memo file and resets the address in the table. The information that was previously stored there is still there, just in a location that is not referenced anywhere.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform