General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
-snip-
>
>>Going through ODBC is definitely going to be slower than OLEDB for my application.
>
>This I don't understand. What is it that you are accessing that you feel OLE DB would be faster than ODBC? OLEDB is an inherently slower technology than ODBC, and there are ODBC drivers for everything you might need.
>
I'd disagree here. OLEDB would be inherently slower only if you use the OLEDB provider for ODBC, where OLEDB's would be an additional layer of abstraction. When there is an OLEDB provider for a data source there's no inherent disadvantage of one over the other.
In fact, I've run tests that indicate OLEDB is faster than ODBC. I've done this for a VFP program that reads data from SQL Server where there is an ODBC driver as well as an OLEDB provider. In this case OLEDB is slightly faster on approx. 50K rows.
In the case of VFP data I must admit I haven't run any comparisons between the ODBC driver and the OLEDB provider, so if that's what you are talking about then this may not apply.
Previous
Next
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