Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
BINTOC() and CDX size
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00173567
Message ID:
00173644
Vues:
24
>An integer takes four bytes in an index and the table. BINTOC() creates a 4-character string which also takes 4 bytes. You can't compress an integer index any further.
>
>Christof

That's what I originally thought. If you look at the solution.app that comes with VFP it tells a different story; namely, that index sizes go in the following order:

Int = C(8) = str(Int) > N(8) > BINTOC(N(8)) = BINTOC(Int)

I just tried making all four indexes STR(Int) and it doubled the index size. Obviously, solution.app is wrong. Only BINTOC( , 1) or BINTOC(,2) would be an improvement over integer. Thanks for your help.
----------
Mark Bucciarelli
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform