RE: ODBC performance with ADO

Поиск
Список
Период
Сортировка
От Hiroshi Inoue
Тема RE: ODBC performance with ADO
Дата
Msg-id EKEJJICOHDIEMGPNIFIJCEKEEPAA.Inoue@tpf.co.jp
обсуждение исходный текст
Ответ на ODBC performance with ADO  (Enrico Gava <enrico.gava@tiscalinet.it>)
Ответы RE: [ODBC] ODBC performance with ADO
Список pgsql-odbc
> -----Original Message-----
> From: Enrico Gava
>
> Hi,
> I'm trying to access PostgreSQL table from Visual Basic using ADO
> with ODBC
> Provider. I am using the Postgres ODBC driver version 7.01.00.05.
> The problem is that to obtain a readonly recordset of 5000

What command are you issuing ?

> records it takes
> around 15 seconds.

Could you show me the table definiton ?
It takes 1~3 seconds to obtain 5000 or more records using ADO.

regards,
Hiroshi Inoue

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