Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo Bloat during update routine...
Message
From
01/12/1999 12:42:02
Fred Taylor
Phoenix, Arizona, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Memo Bloat during update routine...
Miscellaneous
Thread ID:
00296936
Message ID:
00297379
Views:
23
>Fred,
>
>My tests prove VFP6 SP3 is correctly reusing memo space allocation. VFP5.0a has the serious bug.
*snip*
>Visual FoxPro 06.00.8471.00 for Windows [Apr 16 1999 03:38:21] Product ID xxxxx-xxx-xxxxxxx-xx
>
> "no memo contents" "MEMOBLOAT00064.DBF"       1261 "MEMOBLOAT00064.FPT"        512
> "one char pass 1" "MEMOBLOAT00064.DBF"       1261 "MEMOBLOAT00064.FPT"       6912
> "one char pass 2" "MEMOBLOAT00064.DBF"       1261 "MEMOBLOAT00064.FPT"       6912
> "memo length        55" "MEMOBLOAT00064.DBF"       1261 "MEMOBLOAT00064.FPT"       6912
> "memo length        56" "MEMOBLOAT00064.DBF"       1261 "MEMOBLOAT00064.FPT"       6912
> "memo length        57" "MEMOBLOAT00064.DBF"       1261 "MEMOBLOAT00064.FPT"      19712
> "memo length        58" "MEMOBLOAT00064.DBF"       1261 "MEMOBLOAT00064.FPT"      19712
> "memo length        59" "MEMOBLOAT00064.DBF"       1261 "MEMOBLOAT00064.FPT"      19712
> "memo length        60" "MEMOBLOAT00064.DBF"       1261 "MEMOBLOAT00064.FPT"      19712
> "memo length        61" "MEMOBLOAT00064.DBF"       1261 "MEMOBLOAT00064.FPT"      19712
> "memo length        62" "MEMOBLOAT00064.DBF"       1261 "MEMOBLOAT00064.FPT"      19712
> "memo length        63" "MEMOBLOAT00064.DBF"       1261 "MEMOBLOAT00064.FPT"      19712
> "memo length        64" "MEMOBLOAT00064.DBF"       1261 "MEMOBLOAT00064.FPT"      19712
> "memo length        65" "MEMOBLOAT00064.DBF"       1261 "MEMOBLOAT00064.FPT"      19712
> "memo length        66" "MEMOBLOAT00064.DBF"       1261 "MEMOBLOAT00064.FPT"      19712
> "100 replacements" "MEMOBLOAT00064.DBF"       1261 "MEMOBLOAT00064.FPT"      19712
> "one char pass 3" "MEMOBLOAT00064.DBF"       1261 "MEMOBLOAT00064.FPT"      19712
> "emptied" "MEMOBLOAT00064.DBF"       1261 "MEMOBLOAT00064.FPT"      19712
> "one char pass 4" "MEMOBLOAT00064.DBF"       1261 "MEMOBLOAT00064.FPT"      26112
*snip*

David,

I ran your code and did NOT get the same results as follow:

Visual FoxPro 06.00.8492.00 for Windows [May  7 1999 17:04:59] Product ID xxxxx-xxx-xxxxxxx-xxxxx
 
 "no memo contents" "MEMOBLOAT00064.DBF"       1261 "MEMOBLOAT00064.FPT"        512
 "one char pass 1" "MEMOBLOAT00064.DBF"       1261 "MEMOBLOAT00064.FPT"       6912
 "one char pass 2" "MEMOBLOAT00064.DBF"       1261 "MEMOBLOAT00064.FPT"      13312
 "memo length        55" "MEMOBLOAT00064.DBF"       1261 "MEMOBLOAT00064.FPT"      19712
 "memo length        56" "MEMOBLOAT00064.DBF"       1261 "MEMOBLOAT00064.FPT"      26112
 "memo length        57" "MEMOBLOAT00064.DBF"       1261 "MEMOBLOAT00064.FPT"      38912
 "memo length        58" "MEMOBLOAT00064.DBF"       1261 "MEMOBLOAT00064.FPT"      51712
 "memo length        59" "MEMOBLOAT00064.DBF"       1261 "MEMOBLOAT00064.FPT"      64512
 "memo length        60" "MEMOBLOAT00064.DBF"       1261 "MEMOBLOAT00064.FPT"      77312
 "memo length        61" "MEMOBLOAT00064.DBF"       1261 "MEMOBLOAT00064.FPT"      90112
 "memo length        62" "MEMOBLOAT00064.DBF"       1261 "MEMOBLOAT00064.FPT"     102912
 "memo length        63" "MEMOBLOAT00064.DBF"       1261 "MEMOBLOAT00064.FPT"     115712
 "memo length        64" "MEMOBLOAT00064.DBF"       1261 "MEMOBLOAT00064.FPT"     128512
 "memo length        65" "MEMOBLOAT00064.DBF"       1261 "MEMOBLOAT00064.FPT"     141312
 "memo length        66" "MEMOBLOAT00064.DBF"       1261 "MEMOBLOAT00064.FPT"     154112
 "100 replacements" "MEMOBLOAT00064.DBF"       1261 "MEMOBLOAT00064.FPT"    1434112
 "one char pass 3" "MEMOBLOAT00064.DBF"       1261 "MEMOBLOAT00064.FPT"    1440512
 "emptied" "MEMOBLOAT00064.DBF"       1261 "MEMOBLOAT00064.FPT"    1440512
 "one char pass 4" "MEMOBLOAT00064.DBF"       1261 "MEMOBLOAT00064.FPT"    1446912
Notice how my memo files are going up in size where yours did not. Now I notice that your version of VFP6 does not seem to have SP3 applied. Is this correct? Your version is : (SP2????)
Visual FoxPro 06.00.8471.00 for Windows [Apr 16 1999 03:38:21]

Where mine is : (Definitely SP3)
Visual FoxPro 06.00.8492.00 for Windows [May 7 1999 17:04:59]

Could this be the problem?

I ran my test on a W95a P200 88MB ram.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Reply
Map
View

Click here to load this message in the networking platform