Very large queries with ODBC

From: markw <markw(at)mohawksoft(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Very large queries with ODBC
Date: 2002-11-22 03:57:14
Message-ID: 3DDDAB1A.7000504@mohawksoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc


I am trying to execute a query that will return 8 million rows. The next
query I will need will return 45 million rows.
I have useDeclareFetch enabled.

I've traced into the ODBC code, and it seems like previous rows are
never discarded. This makes large queries, i.e. ones where you will be
doing bulk processing for OLAP, impossible.

Is this a known bug? (Is it a bug at all or a feature of ODBC?)
Are there, or would there be, plans to correct it?
If so, what is the strategy?

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Glen Parker 2002-11-22 05:26:18 Bug in latest ODBC driver (07.02.0004)
Previous Message Han 2002-11-22 03:49:54 "#if (ODBCVER >= 0x0399)" in info.c?