Information générale
Catégorie:
Codage, syntaxe et commandes
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
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