Re: Very large queries with ODBC

That's MUCH better.

One suggestion, and maybe I did configure it correctly, but I had to
ODBCINSTDIR to an include file. Using --with-odbcinst=/usr/etc didn't
seem to work.

How much communication do you guys have with the unixODBC people? It
would be cool if there were some way to pick up their settings at either
runtime or comple time.

Hiroshi Inoue wrote:

> Please download the tar ball for *nix provided at
> http://odbc.postgresql.org/
> regards,
> Hiroshi Inoue
> -----Original Message-----
> From: markw [mailto:markw(at)mohawksoft(dot)com]
>
>
> Hiroshi Inoue wrote:
>
>>-----Original Message-----
>>From: markw [mailto:markw(at)mohawksoft(dot)com]
>>
>>Hiroshi Inoue wrote:
>>
>>-----Original Message-----
>>From: markw
>>
>>>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.
>>>
>>>Is it true ?
>>>
>>>Which part of it?
>>>
>>>The last part i.e.
>>> I've traced into the ODBC code, and it seems like previous rows are
>>> never discarded.
>>>
>>>BTW which source code did you track into ?
>>>Are you looking at
>>>//http://gborg.postgresql.org/project/psqlodbc/projdisplay.php ?
>>>
> I was looking at the PostgreSQL 7.2.3 standard source.
>