Re: Very large queries with ODBC

Поиск
Список
Период
Сортировка
От markw
Тема Re: Very large queries with ODBC
Дата
Msg-id 3DE226AA.8000006@mohawksoft.com
обсуждение исходный текст
Ответ на Very large queries with ODBC  (markw <markw@mohawksoft.com>)
Список 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 по дате отправления:

Предыдущее
От: "Dave Page"
Дата:
Сообщение: Re: Source Tarball
Следующее
От: "Bruce Holt"
Дата:
Сообщение: inserting blob data