>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