Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CURSOR Experiencing Memo Bloat
Message
 
 
À
19/07/2006 07:52:20
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
01136610
Message ID:
01137546
Vues:
29
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--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform