Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Speed of SEEK, SEEK(), LOCATE, and SQL SELECT
Message
De
01/07/1999 18:15:58
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00235086
Message ID:
00236754
Vues:
19
>Hi Peter,
>
>Take out the "into array" clause of the SQL statement and compare again. No fair timing the creation of an array for the SQL-SELECT part of the test. <g>
>

Re:

> select cName from SEEKTEST ;
> where SEEKTEST.iOWNERS = lnKey ;
> into array laName
> endfor

I'll try some variations. Were you thinking that select into a cursor/table would be faster or slower than this?


>Also, try the new INDEXSEEK(), which doesn't move the record pointer (as SEEK() does), Am curious to see how it does.
>
>Susan

Don't have V6 yet, but it sounds good.

Peter
Peter Robinson ** Rodes Design ** Virginia
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform