ODBC API speed question

Given the same set of ODBC APIs, is there any tangible speed difference in VC++ compared to  VB?
Diana_palAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
KangaRooConnect With a Mentor Commented:
I would expect the ODBC API and the DB activity to be the most costly. If most of what is done consists of ODBC api calls I expect little difference. If a few ODBC calls are combined with (many) algorithms with high complexities the balance might favor C++.
0
 
abancroftCommented:
Assuming you are using the VB "declare" keyword to access the ODBC API, I would think that the speed difference in calling ODBC functions would be very small.

My reasoning: the ODBC API is implemented in a set of DLL's and the overhead of calling a DLL function in VB is pretty small (compared to VC). In this case, it will have to convert from BSTR to char* for some API calls, but this isn't too costly a procedure.

However, if you use the Jet engine to access the ODBC data source, you may find VB is slower. As ever, it depends on the program.

As KangaRoo pointed out, in most DB programs the DB activity is the bottleneck - not the API calls.
0
 
Diana_palAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.