Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo field bloat
Message
 
 
To
23/02/2000 10:01:14
Paul Robinshaw
Silkworm Technologies Limited
Macclesfield, United Kingdom
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00335984
Message ID:
00335991
Views:
20
It sounds as though you do have memo bloat. You are going to have to pack the table (or at least the memo field).

If your table is very active then memo fields aren't very efficient. Each time memo data is changed, VFP takes what was previously in the field, copies it with the additional stuff and puts it at the end of the memo file. At 800 lines per record, you could be adding 64K to the memo file each time someone edits something.
Larry Miller
MCSD
LWMiller3@verizon.net

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

Click here to load this message in the networking platform