Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Extra memo
Message
De
28/02/2008 12:54:12
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
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 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01297347
Message ID:
01297470
Vues:
13
>>Maybe not if the memo is just a log - it would never have been updated, hence no unused blocks.
>
>I hear what you are saying, but I would at least try it before changing the block size. The default is 64 bytes and the smallest you can set it is 33 bytes. Unless he has over 10M records in that table, you are not going to notice a big difference. And if he changes it to 67 bytes it will get worse instead of better.

The optimal blocksize can be calculated from the lengths, that shouldn't be hard to do, but I agree the exercise may prove to be futile. There's the zero size (i.e. use actual size) option, which may be optimal for a case like this. It minimizes the unused space because it doesn't use blocks. It may have overhead somewhere else, though.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform