Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SPT cursors vs. cursors from local SQL
Message
From
30/07/2009 15:22:14
 
 
To
30/07/2009 15:17:02
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01415555
Message ID:
01415556
Views:
43
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform