Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What is the best index expression?
Message
De
19/04/2005 14:18:11
 
 
À
19/04/2005 13:50:32
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Divers
Thread ID:
01005870
Message ID:
01006299
Vues:
26
Hi Jim,
>
>On the assumption that even Rushmore does NOT provide data from indexes to the program, why would Rushmore's bitmap be of any use when reading records contiguously?

Scenario 1: No records to read at all<g>. Cdx disk IO saved.
Scenario 2: Seek-Scan is used only to speed up, walking in a different order is only a by-product, walking sequence "really" is of no consequence. Scan in the seek-scan scenario has to read the cdx "before" each dbf-record pointer movement. If scanning via Rushmore's bitmap, the dbf-records are accessed via the bitmap and the cdx overhead is saved.

regards

thomas
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform