Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CURSOR Experiencing Memo Bloat
Message
 
 
To
19/07/2006 07:52:20
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
01136610
Message ID:
01137546
Views:
28
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>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform