Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Things that make me go Hmmmm...
Message
De
02/07/1998 15:14:15
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00113468
Message ID:
00113879
Vues:
27
Mike,

I've always had trouble with the idea that Rushmore works faster with *NO* order set.

Since you seem to speak somewhat (at least) knowledgeably regarding this "map" concept, perhaps you could clarify this for me?

No big deal if you pass on this.

Cheers,
Jim N

>When you're using Rushmore and you issue a command with a FOR condition VFP reads the index and creates a "map" of all of the corresponding records in memory before the record pointer is moved to the first record, then when VFP needs to move to a new record it gets the next # from the "map." When you use WHILE logic, VFP simply moves the record pointer through the records in index order. On some occasions the code using FOR will be faster and others WHILE will be faster and it's often data dependent. Incidentally, try your code with the FOR condition with order set to 0 and see what the results are, it should be faster.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform