Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Uncommonly large .DBC
Message
 
To
30/05/2002 23:39:55
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00663268
Message ID:
00663271
Views:
13
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
Previous
Reply
Map
View

Click here to load this message in the networking platform