>>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only