Re: Very large queries with ODBC - Mailing list pgsql-odbc

From markw
Subject Re: Very large queries with ODBC
Date
Msg-id 3DE226AA.8000006@mohawksoft.com
Whole thread Raw
In response to Very large queries with ODBC  (markw <markw@mohawksoft.com>)
List pgsql-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@mohawksoft.com]
>
>
> Hiroshi Inoue wrote:
>
>>-----Original Message-----
>>From: markw [mailto:markw@mohawksoft.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.
>



pgsql-odbc by date:

Previous
From: "Dave Page"
Date:
Subject: Re: Source Tarball
Next
From: "Bruce Holt"
Date:
Subject: inserting blob data