Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Minimum File Size
Message
 
 
To
10/12/2001 16:18:30
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00592376
Message ID:
00592380
Views:
16
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform