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?
Search found 5 matches
- Sat Jun 21, 2014 10:56 pm
- Forum: ODBC
- Topic: Re: improving ODBC data fetch time
- Replies: 0
- Views: 12657
- Wed May 21, 2014 6:40 pm
- Forum: ODBC
- Topic: SQLFetchScroll not returning results
- Replies: 4
- Views: 18326
Re: SQLFetchScroll not returning results
So I figured out the cause of the problem. I was providing a NULL for StrLen_or_Ind in SQLBindCol( SQLHSTMT StatementHandle, SQLUSMALLINT ColumnNumber, SQLSMALLINT TargetType, SQLPOINTER TargetValuePtr, SQLLEN BufferLength, SQLLEN * StrLen_or_Ind); I figured it out by using SQLGetDiagRec to print th...
- Mon May 19, 2014 7:26 pm
- Forum: ODBC
- Topic: SQLFetchScroll not returning results
- Replies: 4
- Views: 18326
Re: SQLFetchScroll not returning results
The bindings on all the columns is successful. But the first call to SQLFetchScroll returns -1.
- Sat May 17, 2014 4:49 am
- Forum: ODBC
- Topic: SQLFetchScroll not returning results
- Replies: 4
- Views: 18326
SQLFetchScroll not returning results
Hi,
I am facing a strange situation. I have bound 240 columns and when I try to use SQLFetchScroll to fetch the results, it errors out. However, when I reduce the number of bound columns to 230, it works fine. Is there some sort of a limit I am reaching?
I am facing a strange situation. I have bound 240 columns and when I try to use SQLFetchScroll to fetch the results, it errors out. However, when I reduce the number of bound columns to 230, it works fine. Is there some sort of a limit I am reaching?
- Fri May 24, 2013 7:09 pm
- Forum: Vertica Performance Tuning
- Topic: Resource Usage on Vertica
- Replies: 1
- Views: 5099
Resource Usage on Vertica
When I look at the resource usage for my query I see that the thread count is 37. Why is my query using so many threads?