Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Minimizing Table Sizes
Message
 
 
À
27/08/2007 09:09:19
Mike Yearwood
Toronto, Ontario, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Vista
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01250525
Message ID:
01250736
Vues:
11
>>>Little. Numeric fields that have no decimals, can be changed to int, saving significant space.
>>
>>Mike,
>>
>>The Numeric (N) fields are stored in a table as string, including dot and minus sign, if present, each occupying one byte
>
>Thanks, I know. A change from 12 to 9 will make relatively little difference, no? But an int can be a more significant change going from 10 characters to 4 bytes.

Sorry I missread you post. Yes, converting numeric to integer will provide bigger difference.
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform