Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CURSOR Experiencing Memo Bloat
Message
From
19/07/2006 08:03:46
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
01136610
Message ID:
01137547
Views:
26
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