Unanswered: Slow data fetching from DB2 in C++ Application
My application that is fetching data from DB2 using CLI API.
The application is getting complete data from a table in bulks by using Default forward cursor in SQLFetchScroll(SQL_FETCH_NEXT).I am facing a problem that the data retrieval from DB2 using CLI is very slow i want to make it efficient .
Currently I am able to fetch 1GB data in 50 minute that is very slow.
what is the efficient way to get data from DB2 using CLI ?