Solved

ODBC API speed question

Posted on 2000-03-01
3
244 Views
Last Modified: 2010-04-10
Given the same set of ODBC APIs, is there any tangible speed difference in VC++ compared to  VB?
0
Comment
Question by:Diana_pal
3 Comments
 
LVL 7

Accepted Solution

by:
KangaRoo earned 50 total points
ID: 2572179
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
 
LVL 4

Expert Comment

by:abancroft
ID: 2581453
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
 

Author Comment

by:Diana_pal
ID: 2594865
Thanks
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Compile GLUT with Visual Studio 2015 1 146
FMX enumerated colours 2 100
Precision Problem in C++ 7 32
Autosar OS Multicore Share Resources confusion ? 2 38
Errors will happen. It is a fact of life for the programmer. How and when errors are detected have a great impact on quality and cost of a product. It is better to detect errors at compile time, when possible and practical. Errors that make their wa…
What is C++ STL?: STL stands for Standard Template Library and is a part of standard C++ libraries. It contains many useful data structures (containers) and algorithms, which can spare you a lot of the time. Today we will look at the STL Vector. …
The viewer will learn how to user default arguments when defining functions. This method of defining functions will be contrasted with the non-default-argument of defining functions.
The viewer will learn how to clear a vector as well as how to detect empty vectors in C++.

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question