Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Simple question on ADO usage
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00408085
Message ID:
00409799
Vues:
18
>>How about speed? I suppose your framework is built around VFP Cursors and it >>may be too much work but, if you are working with SQL Server the OLEDB >>provider is at least twice as fast as SPT with ODBC.

Did you use the CALL syntax when making that comparison? Its alot faster than EXECUTE when running stored procedures.

Someone by the name of Beth Massi, I think, did some comparison testing on this. She has a web site where she posted the results. Saw it in another news group. Sorry, don't have the address.

Even if ADO was faster at returning a recordset from a stored procedure, VFP is more flexible. Its OOP framework extends to data and ADO doesn't. This is exactly why I prefer SPT.

Charlie
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform