Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BINTOC() and CDX size
Message
From
07/01/1999 12:36:50
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00173567
Message ID:
00173628
Views:
28
Perhaps if you know you aren't in for big integers, you can consider BINTOC(...,2)



>Hi Mark,
>
>>I changed all four index expressions to BINTOC( ... ), reindexed, refreshed the view in file explorer and expected the CDX file to be smaller, but it wasn't--exactly the same # of bytes.
>
>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
Kenneth.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform