Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CURSOR Experiencing Memo Bloat
Message
From
19/07/2006 10:28:41
 
 
To
19/07/2006 10:26:18
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
01136610
Message ID:
01137605
Views:
20
Hi Grady. Not in the way at all. It's a discussion about how to possibly avoid the bloat in the first place and hence avoid the need for a pack under certain circumstances.


>Hi - just passing by - has anyone tried pack memo? Or am I just getting in the way?
>
>>Ah ha! Many thanks :)
>>
>>
>>>You have to open table exlusivelly otherwise FoxPro will not reuse memo space.
>>>
>>>>
>>>>CLEAR
>>>>
>>>>CREATE TABLE bloattest (mymemo m)
>>>>APPEND BLANK
>>>>replace mymemo with replicate("X", 1000)
>>>>USE
>>>>DIR bloattest.FPT to FILE bloat_test.txt
>>>>
>>>>USE bloattest
>>>>replace mymemo with replicate("X", 1000)
>>>>USE
>>>>DIR bloattest.FPT  to FILE bloat_test.txt
>>>>
>>>>USE bloattest
>>>>replace mymemo with replicate("X", 1000)
>>>>USE
>>>>DIR bloattest.FPT  to FILE bloat_test.txt
>>>>
>>>>USE bloattest
>>>>replace mymemo with replicate("X", 1000)
>>>>USE
>>>>DIR bloattest.FPT to FILE bloat_test.txt
>>>>
>>>>
>>>>I get this result:
>>>>
>>>>
>>>>BLOATTEST.FPT
>>>>
>>>>     1536 bytes in 1 file.
>>>>
>>>>     2560 bytes in 1 file.
>>>>
>>>>     3584 bytes in 1 file.
>>>>
>>>>     4608 bytes in 1 file.
>>>>
>>>>
>>>>In other words, even though I am replacing the exact same size of memo text it seems to be increasing the FPT file nonetheless. Any ideas?
>>>>
>>>><snip>
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform