Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Xbase commands Vrs Sql commands
Message
De
08/05/2005 15:49:15
 
 
À
07/05/2005 11:39:27
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 6 SP5
Database:
Visual FoxPro
Divers
Thread ID:
01011885
Message ID:
01012035
Vues:
21
>I would imagine this:
>
>SELECT * FROM mytable INTO CURSOR mycursor
>
>would be faster than:
>
>create cursor mycursor (field definitions)
>select mytable
>scan
>scatter memvar memo
>insert into myCursor from memvar
>endscan

That's an unfair comparison, as SELECT * FROM mytable without
any WHERE clause will surely cause a FILTER cursor,
which would compare to USE mytable. That again is
xbase code and faster than the sql select.

Bye, Olaf.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform