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 16:10:29
Message-ID: EKEJJICOHDIEMGPNIFIJAEKIEPAA.Inoue@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
> -----Original Message-----
> From: Enrico Gava [mailto:enrico(dot)gava(at)tiscalinet(dot)it]
> 
> >> 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 ?
> > 
> recordset.open "select * from table_name" 
> the cursor is ForwardOnly, the lock is ReadOnly
> it's the same with Connection.execute "select * from table_name"
> 
> >> 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.
> 
> it's a simple test table:
>   ID         int4
>   LastName   varchar(30)
>   FirstName  varchar(30)
>  

Hmm it doesn't take that long even on a table with 30 columns here.
Aren't you turning on mylog debug ? i.e Aren't there mylog_xxxx.log
files under C:\ ? If so
Ensure that the ODBC driver is not in Debug mode (i.e. set
HKEY_LOCAL_MACHINE\Software\ODBC\ODBCINST.INI\PostgreSQL\Debug = 0
using regedit).

regards,
Hiroshi Inoue

In response to

pgsql-odbc by date

Next:From: Randall PerryDate: 2001-07-23 01:37:15
Subject: Filemaker and pgsql
Previous:From: JosephDate: 2001-07-21 11:43:45
Subject: RE: Access 97 - problems with the result set

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