Hi All,
We are using ODBC oracle driver to access 10g Oracle server from C++ application. But the performance is very slow. Recently we tried with Microsoft Oracle ODBC driver, which we found faster than 10.2.0.4 Oracle ODBC driver.
Please let me know is anything is there any issue with this driver or is it better to use Microsoft ODBC driver.
Thanks,
Trevor.
No there is no any issue with it, I think you should go with it. It will be beneficial to use Microsoft ODBC. I ma sure you will not find any problem in it.
If you find the latest version of the ODBC driver and that will work faster then older version then you don't have any problem so you don't have to worry at all. Actually your PC was sloe because of the C++ compiler. It is heavy program that can burn more RAM.
In general the ODBC driver adds another layer into the mix. It has to take your query and translate it to the native query language That translation/interpretation adds a performance overhead which is worse for some data sources than others.
ODBC stands for the Oracle Data Base Connectivity which driver adds another layer into the mix. It has to take your query and translate it to the native query language That translation/interpretation adds a performance overhead. As the ODBC connection that is required that to connect with the server it.
The ODBC driver adds another layer into the mix. It has to take your query and translate it to the native query language where the native language ins't SQL, or its full implementation. That translation/interpretation adds a performance overhead which is worse for some data sources than others.