Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Auto incr number or GUID?
Message
From
28/10/2003 01:34:04
Dorin Vasilescu
ALL Trans Romania
Arad, Romania
 
 
To
27/10/2003 10:25:38
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00842581
Message ID:
00843389
Views:
22
Agree, but with indexes is another story :)
B-tree indexes are complicated structures, with roots, nodes, keys, pointers.
Check this link for detailed info:
http://www.istis.unomaha.edu/isqa/haworth/isqa3300/fs010.htm

>Hi,Dorin-
>
>PMFJI, but just a comment-
>
>>After 100000 inserts
>>
>>The index size is 2,994,176 bytes
>>
>>After Reindex is 2,161,152 bytes
>>
>>I think that is because are random generated.
>>From what I've read about B-tree indexes, this can be the cause.
>
>VFP tables are fixed width, so 16 bytes is 16 bytes regardless of how the data is generated.
Previous
Reply
Map
View

Click here to load this message in the networking platform