Fast data fetch

[Former Member]

Hi, what is the most efficient way to fetch data into memory from Sybase IQ database with C++?

Is using SAP IQ Database API for C/C++ much faster than using ODBC, or there is no big difference between this two APIs?

Thank you

[c_baker · Accepted solution]

Both the C/C++ API and ODBC natively use the SQLA/IQ cmdseq protocol.

I think it depends on your coding preference and style and any overhead of the ODBC Dirver Manager vs. using the API directly.

Either way your code might dictate how fast results are returned e.g. multi-row fetches and buffering.

In ODBC's favour, the driver manager usually takes care of loading the shared libraries/DLLs and, you can adjust some of the connection properties in the DSN definition, which might make tuning and perhaps some of the coding easier.

Chris

[Former Member · Accepted solution]

Thank you for your answer, and tell me please:

1) Does ODBC driver supports features "e.g. multi-row fetches and buffering" and other for fast data fetch, or there exists some features, that supports only using native API?

2) How large can be overhead of the ODBC Driver Manager vs using API directly, considering that my code will be as fast as possible?