Driver seems to hang fetching data

Поиск
Список
Период
Сортировка
От Patrick Hatcher
Тема Driver seems to hang fetching data
Дата
Msg-id OFC937A75F.D750BDF0-ON88257290.00793E5F-85257290.007AA316@FDS.com
обсуждение исходный текст
Ответы Re: Driver seems to hang fetching data  (David Gardner <david.gardner@yucaipaco.com>)
Re: Driver seems to hang fetching data  (Hiroshi Inoue <inoue@tpf.co.jp>)
Список pgsql-odbc
driver version 8.02.02

I have a query that returns around 30K records.  I have set the cache to
1000 records.  It appears that while pulling data, the driver hangs for
around 30 seconds or more and then continues to the next batch of records.
It does this same sort of behavior whether it caching is set to 100 or
1000. I am using DECLARE/FETCH.
Is there anywhere I can check for the bottle neck?

Thanks.

Patrick Hatcher

В списке pgsql-odbc по дате отправления:

Предыдущее
От:
Дата:
Сообщение: [ psqlodbc-Bugs-1000681 ] Error when using ODBC driver with Microsoft Access
Следующее
От: David Gardner
Дата:
Сообщение: Re: Driver seems to hang fetching data