Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement