Page 1 of 1

Re: improving ODBC data fetch time

Posted: Sat Jun 21, 2014 10:56 pm
by aligardezi
I am at present trying to fetch results for a query that will return approx 35000 rows and 200 fields. (This is our worst case query)

At present by using SQLFetchScroll and fetching one row at a time it takes approx 4 secs.

Q) Are there ways to reduce this time?