Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Speeding up search - Locate For or Seek?
Message
De
28/07/2000 05:18:56
Mike Yearwood
Toronto, Ontario, Canada
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00397065
Message ID:
00398047
Vues:
36
>>
FOR lnJ = 1 TO 10000
SET ORDER TO pID
SEEK(699)
SET ORDER TO
ENDFOR
>>

Hi Brien.

I wouldn't include the set orders in the above code snippet. You already set it before starting this loop. Further, this makes your test not merely compare SEEK against LOCATE.

Try adding SET COLLATE TO "MACHINE" before doing this. SP4 supposedly defaults to something else (?)

SEEK should be way faster than LOCATE.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform