Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What is more efficient of the two
Message
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 8 SP1
Database:
MS SQL Server
Divers
Thread ID:
01135592
Message ID:
01135614
Vues:
10
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
___________________________________________
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform