Search found 5 matches

by aligardezi
Sat Jun 21, 2014 10:56 pm
Forum: ODBC
Topic: Re: improving ODBC data fetch time
Replies: 0
Views: 12435

Re: improving ODBC data fetch time

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?
by aligardezi
Wed May 21, 2014 6:40 pm
Forum: ODBC
Topic: SQLFetchScroll not returning results
Replies: 4
Views: 18067

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...
by aligardezi
Mon May 19, 2014 7:26 pm
Forum: ODBC
Topic: SQLFetchScroll not returning results
Replies: 4
Views: 18067

Re: SQLFetchScroll not returning results

The bindings on all the columns is successful. But the first call to SQLFetchScroll returns -1.
by aligardezi
Sat May 17, 2014 4:49 am
Forum: ODBC
Topic: SQLFetchScroll not returning results
Replies: 4
Views: 18067

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?
by aligardezi
Fri May 24, 2013 7:09 pm
Forum: Vertica Performance Tuning
Topic: Resource Usage on Vertica
Replies: 1
Views: 5062

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?

Go to advanced search