Skip site navigation (1) Skip section navigation (2)

RE: ODBC performance with ADO

From: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
To: "Enrico Gava" <enrico(dot)gava(at)tiscalinet(dot)it>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: RE: ODBC performance with ADO
Date: 2001-07-21 06:30:38
Message-ID: EKEJJICOHDIEMGPNIFIJCEKEEPAA.Inoue@tpf.co.jp (view raw or flat)
Thread:
Lists: 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

In response to

Responses

pgsql-odbc by date

Next:From: Enrico GavaDate: 2001-07-21 09:12:47
Subject: RE: [ODBC] ODBC performance with ADO
Previous:From: Maryann F StophaDate: 2001-07-20 14:15:55
Subject: Re: Access 2000 and ODBC driver Data changed by another user, Copy to Clipboard or Drop changes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group