Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Magic Increasing Memo fields
Message
From
11/03/2002 11:18:50
 
 
To
11/03/2002 10:53:42
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00630993
Message ID:
00631022
Views:
24
Hi Michael,
The basic problem is the way memo fields are managed. Take for example
"qwertyuiop" as the content of your current memo and make a small change to it:
"qwertyuiop{}"
This is now your current memo but the memo file now contains 2 records ("qwertyuiop" mapped out and "qwertyuiop{}" mapped in as your current one that you see. now make another change by deleting the first change and you memo now contains 3 records:
1."qwertyuiop" - mapped out
2."qwertyuiop{}" - mapped out
3."qwertyuiop" - mapped as your current record that you see.
These "old" records remain in the memo as "invisible" records packing the file!
The bigger each memo the bigger the problem and this continues until the memo is packed.
The solution is to pack frequently (daily) or redesign how you hold large amounts of textual data. If this is a "word" document hold pointers to the doc instead.
Buddha Baker
Previous
Reply
Map
View

Click here to load this message in the networking platform