Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Uncommonly large .DBC
Message
 
À
30/05/2002 23:39:55
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00663268
Message ID:
00663271
Vues:
12
This message has been marked as the solution to the initial question of the thread.
>Hi, all
>I've currently found strange thing happened to my .DBC file. The .DBC file belongs to one of my VFP 6.0 application, originally it only has size around 1.5MB, and after several months running, it¡¦s size now glows to 14MB. The number of tables, views, SPs, is just the same as at the time it started running. Why this thing happened and whether this large .DBC will affect the stability and performance. How can I do something for it?
>TIA.

.DBC is a normal DBF file, so the memo fields may bloat.

You can modify your database through Project Manager or from Command window, then go to Menu/Database/CleanUp Database.

You also can open your database as DBF, then PACK it.
USE myDatabase EXCLUSIVE
PACK 
Class libraries .VCX may also bloat.
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform