General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only