Solved

ODBC API speed question

Posted on 2000-03-01
3
246 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
c++ using a LPCOLESTR * and adding a string varaible to the Pointer 2 86
What is sub-make ? 2 102
print bytes of an integer 6 48
Winapi.Windows.hpp problem 7 40
In days of old, returning something by value from a function in C++ was necessarily avoided because it would, invariably, involve one or even two copies of the object being created and potentially costly calls to a copy-constructor and destructor. A…
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 goal of the video will be to teach the user the concept of local variables and scope. An example of a locally defined variable will be given as well as an explanation of what scope is in C++. The local variable and concept of scope will be relat…
The goal of the video will be to teach the user the difference and consequence of passing data by value vs passing data by reference in C++. An example of passing data by value as well as an example of passing data by reference will be be given. Bot…

737 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