Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
.idx vs .cdx
Message
De
14/05/2005 06:46:59
 
 
À
14/05/2005 05:26:31
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Versions des environnements
Visual FoxPro:
VFP 6 SP5
Database:
Visual FoxPro
Divers
Thread ID:
01014169
Message ID:
01014186
Vues:
21
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform