Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CURSOR Experiencing Memo Bloat
Message
From
19/07/2006 10:32:37
 
 
To
19/07/2006 10:28:41
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
01136610
Message ID:
01137608
Views:
20
Well, if a solution isn't found, you can always buy a new Seagate terrabyte hard drive and stop worrying.

>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>
I ain't skeert of nuttin eh?
Yikes! What was that?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform