Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Huge DBC
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00409138
Message ID:
00409262
Views:
15
>Thats done the job - it's shrunk from 100Mb to 86Kb - How on Earth did it get that big in the first place?

I think the biggest reason is changing view definitions or configurations. These are stored in memo fields and each time you make a modification, the memo file will grows because it takes what you just modified and appends it to the end of the memo file and resets the address in the table. The information that was previously stored there is still there, just in a location that is not referenced anywhere.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform