Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo bloat
Message
From
05/10/2005 03:13:27
 
 
To
05/10/2005 03:08:17
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01056130
Message ID:
01056142
Views:
35
>>>John,
>>>
>>>When a new memo is added or an existing is changed the blocks are allocated in 64 byte chuncks, so on average there is a waste of 32 bytes/memo
>>>Changing a memo does not happen 'in place', the whole memo is rewritten, the old apace is not re-used, hence the bloat
>>
>>This is not true, if LEN(memo) it doesn't overcome CEILING(LEN(memo)/BLOCKSIZE)*BLOCKSIZE
>>blocksize it rewritten the memo in place.
>>
>
>
>I was under the impression that it was always rewritten. Is this recent or has it always been like that ?

VFP8,9 certainly, first it is probable


>Then John's setting of 64 is better than 0 if there are a lot of replaces done

sure, set to 0 is good when you fill the memo and don't replace it.

In all the other cases it depends if the replaces become longer or no.
Previous
Reply
Map
View

Click here to load this message in the networking platform