Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Memo bloat
Message
De
05/10/2005 07:31:19
 
 
À
05/10/2005 03:02:29
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:
01056192
Vues:
20
SNIP
>>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.
>
SNIP

Fabio,

Please check out Re: .FPT files - bloat and re-writing of file header Thread #971406 Message #972068

It says, as I read it, that memo field is always re-written.

cheers
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform