Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BINTOC() and CDX size
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00173567
Message ID:
00173644
Views:
23
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform