Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Memo bloat
Message
De
05/10/2005 03:13:27
 
 
À
05/10/2005 03:08:17
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Versions des environnements
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01056130
Message ID:
01056142
Vues:
36
>>>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform