General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2000 Server
>>>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only