Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Minimum File Size
Message
 
 
À
10/12/2001 16:18:30
Steven Dyke
Safran Seats USA
Texas, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00592376
Message ID:
00592380
Vues:
15
>I have a table with several general and memo fields. The file size of the TBK is over 81 megs while the dbl file is under 4 megs. This table is just beginning to be used. What can I do to keep the files as small as possible?

The TBK is just a backup of the FPT file when you modify the structure of the table. You can delete the TBK and BAK files if you are sure you do not need to revert back to the version of the structure and data prior to the last MODI STRU. The file that will bloat is the FPT. The only way to remove the bloat is to PACK or PACK MEMO. You can also copy or sort all the records to a temp table, close the tables, confirm the temp files [DBF and FPT] were created, delete the originals, rename the temp files back to the original file names. Then you have to deal with all the properties, indexes, etc if the table was in a DBC.
Mark McCasland
Midlothian, TX USA
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform