Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Simple question on ADO usage
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00408085
Message ID:
00409799
Views:
17
>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform