Postgres Pro
Downloads
Home   >   mailing lists

RE: ODBC performance with ADO - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject RE: ODBC performance with ADO
Date
Msg-id EKEJJICOHDIEMGPNIFIJCEKEEPAA.Inoue@tpf.co.jp
Whole thread Raw
In response to ODBC performance with ADO  (Enrico Gava <enrico.gava@tiscalinet.it>)
Responses RE: [ODBC] ODBC performance with ADO
List pgsql-odbc
Tree view 
> -----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 by date:

Previous
From: Maryann F Stopha
Date:
Subject: Re: Access 2000 and ODBC driver Data changed by another user, Cop y to Clipboard or Drop changes
Next
From: Enrico Gava
Date:
Subject: RE: [ODBC] ODBC performance with ADO