Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SPT cursors vs. cursors from local SQL
Message
De
30/07/2009 15:22:14
 
 
À
30/07/2009 15:17:02
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 9 SP2
Database:
Visual FoxPro
Divers
Thread ID:
01415555
Message ID:
01415556
Vues:
44
>Why is it that when you get a cursor from SqlExec() using SQL Pass-through calls, you get a ReadWrite type of cursor back, but If you build a SQL Select command against local tables, you have to specify "ReadWrite" in the SQL command? What would it hurt to just always get a ReadWrite cursor back from local Select calls?

Performance. If against local FoxPro tables if your SQL Select is 100% optimized the SQL statement just opens up the table again and filters down the data. It's very quick if you say ReadWrite it will always create a temp table which is slower.
Charles

"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform