Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is there a speed difference between filter and seek ?
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Is there a speed difference between filter and seek ?
Divers
Thread ID:
00417902
Message ID:
00417902
Vues:
46
Here is some code :

SELECT appur
SET FILTER TO ident = the_ident
GO TOP
DO WHILE !EOF()
...do stuff...
SELECT appur
SKIP
ENDDO

I have an index on appur.ident

Would it be faster to do a seek and do the work around it ? And why if the filter is optimized by rushome ?

Thanks
Eric
Eric Crespin
Consultant
PC PLUS Software Inc.
www.pcplus.ca
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform