Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
.idx vs .cdx
Message
From
14/05/2005 06:46:59
 
 
To
14/05/2005 05:26:31
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 6 SP5
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01014169
Message ID:
01014186
Views:
20
Hi Fabio,

>Attention, .idx can to be 2X faster.

usually if I am in need of speedier index I create a temporary index in a ramdisk (helped a lot in NT4, less in more current OS). Since I want to keep things simple for possible transaction and/or datasession scenarios I also use compound indices here - but since this is for speed, I might reconsider and add a way to branch out to use idx. Have you found any rules of thumb under which circumstances (rushmore or seek() ?) the idx is faster ? Perhaps even how much gain can be estimated ? Any hypothesis as to reason ?

regards

thomas
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform