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:
00174910
Views:
23
Christof,

I just ran this test code, I tried 2^i, 2^i - 1 and 2^i + 1

create table itest (i1 i)
index on i1 to itest.idx

for i = 0 to 30
j = 2^i + 1
insert into itest values ( j )
endfor

use

Used a hex file viewer between each run and it does look like bintoc() is stored in the idx. Which is somewhat suprising. There's no word/byte swapping like the integers have in the .dbf itself. So maybe FoxPro is playing some other tricks that make this the fastest way to deal with the index file.

>Only in a compact index. Have you tried to analyze a non-compact IDX index? I think it would be easier with such an index...
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform