Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What is more efficient of the two
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
Database:
MS SQL Server
Miscellaneous
Thread ID:
01135592
Message ID:
01135614
Views:
9
Hi

>The second one is missing SEEK() to find record in the local cursor.

I am scanning the local cursor, it does not require a seek I want to do all records. For each record I will bring a record from SQL based on a PK/FK. A Parent (SQL) -Child (Local) kind a thing.

>Assuming that MySQLPTCursor has less records that local cursor, I would expect the second one to be a little bit faster. Depending on the # of records in the cursor, the difference may be negligible.

Oh, okay.

Thanks.
Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
___________________________________________
venussoftop@gmail.com
___________________________________________
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform